Microsoft VBA training

What this course covers

The course covers VBA fundamentals before moving into the automation scenarios most relevant to your team.

VBA fundamentals

• Understanding the VBA editor – modules, procedures and the project explorer
• Recording and editing macros: how the recorder works and where it falls short
• Variables and data types: storing and working with values in VBA
• Conditional logic: If-Then-Else and Select Case for decision-making in code
• Loops: For Next, For Each and Do While for processing ranges and collections

Excel automation and applications

• Working with Range, Cells and Worksheets objects to read and write Excel data
• Opening, closing, saving and managing workbooks through VBA
• Building custom functions (UDFs) that appear in the Excel formula bar
• Creating UserForms for structured data entry interfaces within Excel workbooks
• Error handling: making macros fail gracefully rather than crashing the workbook unexpectedly
• Optimising code for performance on large datasets

What you will be able to do

• Navigate the VBA editor and understand the structure of modules, procedures and objects
• Write VBA code that reads, writes and manipulates Excel data across ranges and worksheets
• Use loops and conditional logic to automate multi-step, decision-based Excel processes
• Build custom Excel functions using VBA that are available directly in the formula bar
• Create UserForms for structured data entry within Excel workbooks
• Handle errors in VBA code so macros fail gracefully rather than crashing the workbook