1

Development using macros

• Defining and identifying the limits of a macro: Need to use VBA.
• Recording a macro and displaying the code.
• Assigning a macro to a button.
• Using variable dimension ranges.

2

Getting started with Excel VBA language

• Viewing a macro’s code and making simple changes in an editor.
• Identifying what sets different versions of Excel apart.
• Understanding the VBA environment: Modules, projects, objects, and their properties.
• Knowing the main objects of Excel (Workbook, Worksheet, Range), their properties and essential methods.

3

Language structure

• Knowing conditionals: IF ...END IF, SELECT CASE. FOR NEXT, DO WHILE, UNTIL, FOR EACH NEXT loops.
• Understanding variables and constants. Documenting the code.
• Managing runtime errors, debugging.
• Working with procedures and functions. Calls, branches.

4

Dialog box and forms

• Using the message box, input box. Excel dialogs.
• Defining and understanding the role of a UserForm in Excel.
• Describing a form’s different objects, control properties in a form.
• Retrieving, controlling, and using data entered in the form.

5

Event procedures

• Understanding the event procedure. The first workbook and sheet events (Open, Activate).
• Initializing and configuring a control: Control events in UserForm.

6

Communicating with Word or PowerPoint

• Using automation, referencing a library.
• Working with the Application object.