Excel Macros and VBA

Excel Macros and VBA Course summary

For Excel users. Extend the capabilities of Excel with Macros and VBA code.

Outline:
Record simple Excel macros with shortcuts or buttons

• Setting Excel Macro Options

• Record and Run Macros

• The Quick Access Toolbar

Excel VBA Editor

• Use the VBA Editor

• Create, copy and import/export modules

• Starting the Visual Basic Editor, Use Project Explorer

Creating Procedures and Functions
Create macro procedures in code using variables  

• Creating Sub and Function Procedures

• Declare and Use Variables

• Displaying Messages

• Getting Input from the User

Controlling Program Flow

• IF Statement

• Select Case Statement

• For Next Loops and Do Loops

Interacting with a spreadsheet :

• Referencing Cells and Ranges

• Gathering Cell and Range Information

• The Offset Method

• With Blocks

• Referencing Workbooks and Worksheets

Functions

• Standard Excel Functions in VBA

• Custom functions

• Calling functions and sub procedures

User Forms

• Basic design, display and interaction with forms