Excel VBA Course Content

Macro Overview, Recording and Running Macros

• Understanding Macros, their positives and negatives
• Recording Absolute and Relative Macros
• Macro Locations
• Various techniques for running Macros, e.g. buttons, toolbars and menus

Visual Basic Environment

• The Visual Basic Editor, windows and panes
• Editing Macros, Break Points and Stepping
• Basic Editor Formats
• Insert, Removing, Renaming, Exporting/Importing Modules

Syntax Construction, Objects, Methods, Properties and Variables

• Understanding VBA Syntaxes
• Understanding Objects, the Object Hierarchy and Navigation
• Understanding and Using Object Properties
• Understanding and Using Object Methods
• Variables - Local, Modular, Project and Object variables

Control Structures

• Using If, ElseIf and Select Case Structures

Looping Structures

• Do .. Loops
• For .. Next Loops
• For each .. Loops

Functions

• Understanding Functions and their purpose
• User Defined Functions
• Excel Functions
• VB Functions

Interactive Macros + User Forms

• Using Message Boxes and Inputboxes
• Creating User forms and Worksheet Controls
• Calling forms from the worksheet

Error Handling

• Creating Error Handling statements, various techniques to trap errors

Events

• Worksheet, Workbook and Object Orientated events

VB Referencing and Protection

• Understanding Referencing with Word, Outlook and other applications
• Locking VB Code
• Printing and Saving projects
• Creating Add-Inns