Visual Basic for Excel

This course covers the skills required to enable delegates to create user defined functions, understand the VBA environment and use a range of programming techniques to develop automated solutions in excel. This course assumes a strong knowledge of Microsoft Excel to an Advanced level.

At the end of the course delegates will be able to create macros and user defined functions, manipulate Excel objects, create controls and customise the menu systems. This course is available for Microsoft Office 2003, 2007 and 2010

Create Recorded Macros in Excel
The Visual Basic Environment
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Working with Procedures and Functions
Understanding Modules and Creating a Standard Module
Understanding Procedures and Creating a Sub Procedure
Using the Immediate Window to Call Procedures
Creating a Function Procedure and Naming Procedures
Understanding Objects and Navigating the Excel Object Hierarchy
Using the Object Browser
Working with Properties
Using the With Statement and Working with Methods
Creating an Event Procedure, Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables and Understanding Data Types
Using Intrinsic Functions, Understanding Constants
Using Message Boxes and Using Input Boxes
Declaring and Using Object Variables
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Understanding UserForms and Using the Toolbox
Working with the Label Controls, Text Box Controls and Command Button Controls
Working with the Combo Box Controls, Frame Controls and Control Appearance
Setting the Tab Order and Populating a Control
Adding Code to Controls and Launching a Form in Code
Working with the PivotTableWizard Method
Understanding Errors and Using Debugging Tools
Understanding Error Handling
Writing an Error-Handling Routine