Excel VBA Training

REVIEW OF DEVELOPING MACROS

• Create a Macro with the Macro Recorder
• Edit a Macro
• Debug a Macro
• Different ways of running a Macro

THE VISUAL BASIC ENVIRONMENT

• The Project Explorer
• Properties
• Object Viewer

WRITING VBA CODE

• Properties
• Methods
• Objects
• Subroutines
• Immediate Window
• Watch Window

PERFORMING CALCULATIONS

• Create User-defined Functions
• Automate SUM Functions

COMMUNICATING WITH THE USER

• Simple Message Boxes
• Message boxes that return values
• Buttons and icons
• Input Boxes

VARIABLES

• Declaring Variables
• Using Variables
• Watching Variables

CONTROL AND DECISION STRUCTURES

• Conditional Statements
• Decision Structures
• Select Case

LOOPING

• For next loops
• Do While
• Do Until

ERROR TRAPPING

• Understanding error handling
• Understanding VBA error trapping options
• Trapping errors with the on error statement
• Understanding the error object
• Writing an error handling routine
• Working with inline error handling

DEBUGGING THE CODE

• Defining errors
• Working with debugging tools
• Determining breakpoints
• How to step through code
• Working with break mode during run mode
• Identifying the value of expressions

EVENT PROCEDURES

USER FORMS

• Placing controls
• Aligning Controls
• Properties