 |  |  |  |  |  |
| Course | Microsoft Excel VBA | |
| Duration | 2 Days | |
| Overview | This course introduces the student to VBA to automate repetitive tasks. While a good working knowledge is an advantage, experience with the advanced features of Excel is not a prerequisite for this course. | |
| Content | Introduction | Recording & Running Macros Relative & Absolute References |
| Assign Macros to Buttons | Assign a Macro to a Drawing Object
& a Toolbar Button Editing the Toolbar Button |
|
| Editing Macros | VBA Editor Window Project Explorer Procedures, Keywords |
|
| Building Macros | Joining Subroutines | |
| Objects |
Cell and Range Objects |
|
| Objects, Methods & Properties | Controlling Objects with Properties Performing Actions with Methods |
|
| Variables, Arrays and Constants | Variable Data Types Declaring & Assigning Variables |
|
| Procedures & Functions |
Arguments, Named Arguments |
|
| Communicating with the User | Messages & Input Boxes User Defined Forms Adding Controls Controls Properties & Events |
|
| Conditional & Looping Subroutines |
If, Select Case, Do Loops |
|
| The Windows Registry | Set and Get Settings | |
| Debugging & Error Trapping | Errors, Break Mode Instant Watch, Stepping |
|