Microsoft Excel Macros & VBA
Record and edit macros, use the Visual Basic Editor, write procedures, declare variables, control execution flow, handle errors, and build interactive UserForms.
Complete Course Syllabus
Introduction to Macros and VBA
- Introducing Visual Basic for Applications & recording a macro
- Absolute or Relative Cell Referencing & saving files with macros
- Making macros available & assigning to shortcuts, QAT, buttons and shapes
- Editing a macro in the Visual Basic Editor & customising environment
Working with Procedures
- Program design, understanding modules, naming rules, and creating modules
- Creating Subroutines and Functions, arguments, exiting, and calling procedures
- Objects, Properties, Methods, Events, object hierarchy, collections, and object browser
Using Expressions, Variables and Intrinsic Functions
- Expressions and statements, declaring variables, determining data types
- Variable scope, built-in VBA functions, constants, message boxes, and input boxes
Controlling Program Execution
- Control-of-flow structures: If...End If, Select Case, Do...Loop
- For...Next and For Each...Next loops
Debugging and Handling Errors
- Debugging tools, breakpoints, break mode, and stepping through code
- Trapping errors with On Error statements, Err object, and inline handling
Working with Forms and Controls
- Understanding UserForms, creating and displaying forms
- Aligning/sizing controls, Toolbox, properties, and populating controls
More Excel Courses
Microsoft Excel Introduction
Master workbook navigation, efficient data handling, and essential formulas. Create professional-looking spreadsheets, design clear charts, and produce polished print-ready reports.
Microsoft Excel Intermediate 1
Develop practical Excel skills, enabling users to work more efficiently with spreadsheets, organise and analyse data, and present information clearly. Delegates will learn to use Excel Tables, conditional formatting, sorting and filtering, formulas and charts.
Microsoft Excel Intermediate 2
Building on the skills developed in Excel Intermediate 1, this course introduces more advanced formulas, workbook techniques and data analysis tools. Delegates will learn to use logical and lookup functions, work with named ranges and linked workbooks, apply advanced filtering techniques, enhance charts and gain an introduction to PivotTables.