Microsoft Excel VBA and Macro Training

Microsoft Excel VBA and Macro Training Outline

Module 1: Recorded Macros 

• Understanding Excel Macros 

• Enable the Developer Tab 

• Record a Macro 

• Run a Macro 

• Edit a Macro 

• Saving a Document as Macro Enabled 
   

Module 2: Understanding Excel VBA 

• Programming in Microsoft Excel 

• VBA Terminology 

• VBA Editor Screen 

• Viewing the Excel Object Model 

• Using the Immediate Window 

• Setting Property Values 

• Accessing Help 
   

Module 3: Starting with Excel VBA 

• Using the Project Explorer 

• Working with the Properties Window 

• Working with a Code Module 

• Setting Breakpoints in Code 
   

Module 4: Using Excel Objects 

• Application Object 

• Workbook Object 

• Range Object 

• Using Objects in a Procedure 
   

Module 5: Programming Techniques 

• MsgBox Function 

• InputBox Function 

• Simple If Statement 

• If...Then…else Statement 

• Select Case Statement 

• Do Loop 

• For Next Loop 

• For Each…Next Loop 
   

Module 6: Procedures 

• Understanding Procedures 

• Creating a New Sub Routine 

• IntelliSense 

• Commenting Statements 

• Indenting Code 

• Bookmarking in Procedures 
   

Module 7: Using Variables 

• Understanding Variables 

• Creating and Using Variables 

• Explicit Declarations 

• Scope of Variables 

What You’ll Learn in this Course

This course takes you from understanding macro basics to writing custom VBA scripts for advanced automation. Each stage builds the confidence needed to create efficient and automated Excel solutions. 
 

• Learn the fundamentals of VBA and macro recording in Excel 

• Learn how to write and edit VBA scripts for task automation 

• Learn to create custom functions and automate repetitive workflows 

• Learn how to apply logic, loops, and variables in VBA projects 

• Learn to design user forms and interactive Excel-based tools 

• Learn how to debug code and optimise macro performance