Hyper-disambiguated Excel VBA Programming
Grant Gamble
-
-
1.1. Course introduction
4:47 -
1.2. Excel VBA overview
1:40 -
1.3. The Developer Tab
2:52 -
1.4. Macro security
5:48 -
1.5. The Visual Basic Editor and Project Explorer
2:02 -
1.6. Excel objects and event code
7:59 -
1.7. Writing a macro in the VBE
3:57 -
1.8. Using the Immediate window
3:11 -
1.9. Saving a macro-enabled workbook
1:30 -
1.10. The correct way to use the macro recorder
12:50 -
1.11. Analysing a recorded macro
6:58 -
1.12. Improving a recorded macro
11:59 -
1.13. Assigning a macro to a button
12:52 -
1.14. Testing a macro on another worksheet
5:54 -
2.1. The Excel Object Model
12:07 -
2.2. VBA Classes and Functions
11:28 -
2.3. Properties and Methods
12:54 -
2.4. Data Variables
13:27 -
2.5. Object Variables
19:25 -
2.6. Option Explicit
5:25 -
2.7. Declaring and Using Constants
5:49 -
2.8. Using MsgBox for Output
10:11 -
2.9. Using MsgBox for Input
9:30 -
2.10. Using VBA InputBox
6:25 -
2.11. Using Application MsgBox
6:19 -
3.1. If Statements
11:36 -
3.2. If ... Else Statements
13:18 -
3.3. Select ... Case
9:19 -
3.4. For ... Next Loops
9:32 -
3.5. For Each ... Next Loops
6:46 -
3.6. Do ... While Loops
13:56 -
3.7. Do ... Until Loops
7:27 -
3.8. Creating Arrays
10:16 -
3.9. Dynamic Arrays
13:25 -
3.10. Utilizing Arrays
11:05 -
4.1. Sub Procedures and Module-level Variables
10:53 -
4.2. Static Variables
5:29 -
4.3. Passing Parameters
11:29 -
4.4. Creatig and Calling Functions
7:48 -
4.5. Creating User-defined Functions
17:04
-
About This Class
The video tutorials in this course will show you how to automate Microsoft Excel tasks and operations. It is aimed particularly at Excel users, without much programming experience, who struggle to remember the syntax and structure of the VBA programming language. During the course, we will use a style of programming which emphasizes the significance of each line of code that you write. This means that when you revisit the code, the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. The course also demonstrates how to get the maximum benefit from IntelliSense, Microsoft's code completion feature. Whether you are looking to enhance your career prospects, save your company money or increase your productivity, this course will provide your with all the knowledge you need to get started. You can download all of the materials used in the lectures, so that you can follow along. (Please, remember to unZIP the downloaded files.)
Class Projects See All
No projects have
been added yet
No projects have
been added yet
No projects have
been added yet
No projects have
been added yet
1 of 1 students recommendSee All
This is an excellent course. As stated in the beginning, for the casual Excel VBA user, it highlights many of syntax difficulties - which can be a real obstacle when you are trying to get a procedure to work. However, in too many of the videos, the audio at times becomes unintelligible - and you are let wondering what he is saying. A 4-star course - because of the audio problems - which the author should correct.
Grant Gamble is an experienced IT trainer, developer, consultant and author able to deliver a wide range of training courses. He has a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes.
His UK company G Com Solutions Limited provide IT training courses and consultancy to a wide range of UK and international clients. His speciality is running week-long, intensive training workshops on topics like Microsoft Power BI...