1 - USING VBA TO SOLVE BUSINESS PROBLEMS

Use Macros to Automate Tasks in Excel

Identify Components of Macro-Enabled Workbooks

Configure the Excel VBA Environment

2 - RECORDING A MACRO

Use the Macro Recorder to Create a VBA Macro

Record a Macro with Relative Addressing

Delete Macros and Modules

Identify Strategies for Using the Macro Recorder

3 - WRITING VBA CODE DIRECTLY

Write VBA Code

Discover Objects You Can Use

Create a Custom Function

4 - SOLVING PROBLEMS THROUGH CODE

Make Decisions in Code

Work with Variables

Perform Repetitive Tasks

5 - IMPROVING YOUR VBA CODE

Debug VBA Errors

Deal with Errors

Improve Macro Performance

6 - CONTROLLING HOW AND WHEN MACROS RUN

Prompt the User for Information

Configure Macros to Run Automatically