Learn about using Excel macros for automating frequently performed tasks. Learn about the many ways to set up macros, debug and edit macros, as well as the Visual Basic editor and an introduction to VBA programming from scratch. 6 hours

• Automating tasks you perform frequently
• Macro viruses
• Setting your Excel macro security level
• Command macros vs. user-defined functions
• Running a Command macro

Recording a Command Macro

• Visual Basic Toolbar
• Viewing your code

Using the Visual Basic Editor

• Touring the Visual Basic Editor
• Project Explorer
• Properties Window
• Code Area
• Changing Visual Basic Environment Options
• Calling a sub procedure
• Writing a new macro procedure

Running a Command Macro

• Running a macro from the Macro Dialog Box
• Running a macro with a Shortcut Key

Recording More Command Macros

• Creating Macros that open other workbooks
• Creating Macros that tile worksheet windows
• Relative vs. Absolute reference recording

Creating Macros for Printing

• Page Setup

Assigning Macros to Buttons and Menus

• Adding controls using Forms toolbar
• Running a macro from a button or graphic control
• Running a macro from a toolbar button
• Adding a macro to a menu

Using the Personal Macro Workbook

Debugging and Editing a Macro

Creating and Using a Function Macro

Using Dialog Box Controls

• Creating range names
• Using the Forms Toolbar
• Creating a combo box
• Creating scroll bars and spinner controls

VBA Programming from Scratch

• Using the Offset() property
• Using the Range object
• Using the Dim statement
• Using the Cells() property
• Learning more about VBA programming