Microsoft® Excel Macros & VBA Level I Introduction

Click Here For More Information

Creating Excel Macros

Visual Basic vs. VBA
Macro Security
Blueprinting Macro Design
Using the Macro Recorder
Naming Macros
Executing Macros
Using the Visual Basic Editor

Exploring the Visual Basic Language

Modular Programming
Events
Excel Object Hierarchy
Procedure Types: Subs vs. Functions
Objects, Properties, and Methods
With and End With Statements
The MsgBox Function
Command Buttons
The ActiveCell Property
The Offset Property

Course Information
  • Course Level:Advanced
  • Prerequisite:Prior use of Excel at an intermediate level
  • Credit:4 CPE hours
  • Fee:$199
  • Length:half-day

Related Courses