Course length: 1 day
Prerequisites: Excel Introduction, Excel Intermediate, Excel Advanced or equivalent knowledge.
Overview: You will learn to create and edit macros, and gain an understanding of VBA code.

Course content

Lesson 1: Introduction to Visual Basic for Applications

• Running a macro
• Recording a macro
• Examining module design

Lesson 2: Assigning macros

• Specifying the location of recorded macros
• Assigning macros to menus, buttons, and toolbars

Lesson 3: Creating decision-making code

• The If…Then decision structure
• The If…Then…Else decision structure
• The Select Case decision structure

Lesson 4: Using loop structures

• Using a For…Next statement
• Using a Do…Loop statement
• Using a For Each…Next statement

Lesson 5: Macro management

• Personal Macro Workbook
• Assigning Sub procedures to run automatically

Lesson 6: Recording a macro in Word

• Running a macro
• Recording a macro

Lesson 7: Interactive macros

• Creating a custom message box
• Creating a custom input box
• Extracting data from Excel

Return to Courses