Excel 2007 Visual Basic
Categories: Microsoft Excel
Excel 2007 Visual Basic 

Course Contents
The contents of our Excel 2007 Visual Basic course are as follows (any items marked with a * will be covered if time allows).

Not only our best-selling course, but also one of our favourites. This two-day course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling. Microsoft Excel macros are fun - let us show you why!

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
 
Tools
 
Key Details
Duration2 days
 
£550
per delegate