VBA Programming in Excel

Objectives: Delegates will be able to make use of the more powerful features of Microsoft Excel through VBA code.

Pre Requisites: Delegates should be proficient in the use of Microsoft Excel including commands, functions and simple Macros

Duration: 2 days

The topics covered are as follows:

1 Introduction to Macros
• What is a Macro?
• Recording a Macro
• Running a Macro

2 Editing Macros
• The Visual Basic Editor
• The Project Explorer
• The Code Window
• Procedures
• Comments
• Printing a Module

3 The Range Object
• What is the Range Object
• The Cells Property
• The Range Property
• Range Contents

4 Workbooks and Sheets
• Activating a Workbook
• Activating a Worksheet
• This Workbook

5 Objects, Properties and Methods
• Controlling objects with Properties
• Performing Actions with Methods
• Performing Multiple Actions on an Object

6 Variables and Constants Control Structures
• Conditional Control Structures
• Looping Control Structures
• Non-Structured Statements
• Sub Procedures

7 Controls, Dialog Boxes and Forms
• Dialog Boxes
• Custom Forms
• Worksheet Forms
• Setting Properties of a Control
• Adding Controls
• Control and Dialog box Events

8 Storing Information
• The Registry
• Settings Files

9 Using Toolbars
• Toolbars and Menus
• Attaching Toolbars to Workbooks
• Customising Toolbars

10 Debugging and Error Trapping
• Types of Error
• Break Mode
• Instant Watch
• Stepping Through Code
• Error Handling

11 Function Procedures
• Function Procedures
• User Defined Functions
• Function Wizard
• Excel Functions

12 Add-In Applications
• What is an Add-in?
• Creating an Add-In
• Converting an Add-In to a Workbook

microcomputing serves the Tyne & Wear, Northeast England region, with software training courses arranged for all types of companies in Sunderland, Washington, Gateshead and Newcastle as well as County Durham, Northumberland and the Teeside area with courses for organisations in Middlesbrough, Darlington and Stockton.