Excel 2010 VBA Macros
CLASS DATE(s):
Request a Class

COURSE LENGTH: 3 Days

COURSE COST: $1195

COURSE TIMES: 9:00 am - 4:30pm

Printable version of this course
print

COURSE OVERVIEW

This three-day course takes you through Visual Basic for Applications in Excel, all the way from recording Excel VBA macros through to designing your own user forms. On the way you will learn what variables are, how to write object-oriented programs, how to create loops and much more besides.

AUDIENCE AND PREREQUISITES

You must be an Experienced Excel user who wish to automate repetitive tasks or simplify more complex tasks using Excel 2010 Macros and Visual Basic for Applications (VBA) programming language.

You must have good Excel skills and understand key concepts of spreadsheets or equivalent. It is not necessary to have prior programming knowledge. We cover VBA Macro programming concepts from the very basic level.

Excel 2010 Level 1, 2 & 3.

PREREQUISITE COURSESFOLLOW UP COURSES  

*Course cost listed does not include the cost of courseware or lunch. Course is subject to minimum enrollment. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.

COURSE TOPICS:


Recording macros and buttons
Absolute and relative recording
Where macros can be stored
Assigning macros to buttons

Selecting cells
Selecting cells (absolute)
Selecting cells (relative)
Selecting to the end of a block
Selecting a range by its corners
The VB code editor
Using Project Explorer
Creating modules
Basic subroutines and comments

Messages and variables
Input boxes and message boxes
Declaring variables
Option Explicit
Scope of variables
Constants

Visual Basic Explained
The Excel object model
Objects and collections
Methods and properties
Getting help in VBA

Loops and conditions
Simple IF conditions
Multiple IF and SELECT /CASE
Three main types of loop

Looping over collections
Object variables
Looping over collections

Event handling
Assigning macros to events
Cancelling events

Functions
Declaring functions
Passing arguments
Debugging and error handling
Setting breakpoints
Stepping through macros
ON ERROR statements

Forms
Drawing forms
Attaching macros to controls
Validating form input

Referencing other applications
Links to Word or Access
Working with files and folders