Description

An overview of Excel Visual Basic for Applications and an introduction to the macro recorder. Navigate around the Visual Basic Editor and record and run macros to automate repetitive procedures.

Learning Objectives

---

1. Identify the steps to enable the Developer tab in Excel to access the VBA editor.
2. Apply the process of writing and running a simple macro in the VBA editor.
3. Differentiate between the various components of the Excel VBA environment, such as the Project Explorer, Properties window, and Code window.
4. Use the Macro Recorder to automate a series of actions in Excel and save them as a macro.
5. Analyze the common VBA concepts, including variables, loops, and If statements, to create efficient and effective macros.