Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0

Topics include: recording/running macros, relative mode, macro icons, buttons/menus, Visual Basic enhancements using objects, properties, methods, events, variables, constants, dialog boxes, "IF" controls, loops & using the editor and Object Browser.

Course Outline

This course explores creating, editing, and using Excel Macros and provides a good introduction to the relationship between macros and Visual Basic. 

This course is classroom style instruction: Instructor-led, hands-on training.

Basic Macro Concepts
Macros And Sub Procedures
Limitations Of Recorded Macros

Recording Macros
Relative Referencing
Macro Options
Storing Macros
Editing A Macro
Debugging A Macro
Step Into, Step Over, Step Out
Run To Cursor
Seven Ways To Run A Macro; Adding To Toolbars, Creating Buttons, Etc.

Visual Basic
Defining Projects, Modules, Sub Procedures, Statements, And Events
The Visual Basic Editor
Views And Icons
Adding Comments
Checking Syntax Errors
Sub Procedures
Structures Of Sub Procedures

Working With
Object Names

Common Properties
Using The With Command
Properties That Are Objects

Common Methods

The Object Browser
Project/Library Box

Variable Types
String Variables
Date Variables
Declaring Several Variables

User Interaction
Input Boxes
Converting Input Box Answers
Message Boxes
Building Messages
Special Characters To Sue When Concatenating
Message Box For Input
Status Bar Messages
Flow Of Control
If … Then Statements
If  … Then … Elseif
Running Other Procedures From Within Procedures
If Statements With Message Boxes
For … Next Loops
Do While … Loops

Event Trapping
Auto_Open And Auto_Close
On Error Go To
Application Event Properties
Other Objects’ Event Properties

Working With Other Programs
Opening / Sending Commands To
Linking Up With Libraries

Prerequisites & Certificates

Course Prerequisite: Required: Solid understanding of all Excel Introduction, and Intermediate Levels I & II topics. Recommended: Knowledge of Excel Advanced topics.

Certificates offered

Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion

Cancellation Policy

Map & Reviews
Computer Help
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 386 times.