EXCEL · 2 Days

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.

Duration: 2 Days From £550/day (up to 8 learners) 1-to-1 or Groups of up to 8 Learners (Larger by Arrangement) M365 (Desktop & Web) · Office 2021/2024 Certificate · Manuals · 1-Year Support

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
Copied to Clipboard ✓

Ready to Share