•  Complete advanced elements of VBA
•  Adopt programming best practice

• Conduct error trapping
• Employ a range of additional variables
• Use data from a Word document
• Create forms with controls
• Add a calendar for data entry
• Customize Excel
• Create runtime applications and add-ins
• Run Access from VBA
• Build a Function library
• Employ Class Modules

Review of the VBA Introduction course key elements

 

Error Trapping and the CASE statement

Building a generic Error handler

Testing for Errors with “Raise”

 

More on Variables

Multi-Dimension array variables

Performance improvement

Public Variables

Data type conversion

 

Using Data from MS Word

Building an Array from a Word document

 

Controls Dialogue Boxes and Forms

Built-In & Predefined Dialogue Boxes

Custom, Worksheet & User Defined Forms

Adding Form Controls - including

Combos

Option Frames

Calendar

Form Control Properties

Multi-choice Controls

Control & Dialogue Box Events

Displaying & Dismissing a User Form

 

Toolbars & Display

About Toolbars & Menus

Customised Menus

Display

 

Adding a Calendar Control to a sub-menu

Use the Calendar for data entry

 

Customising the Excel environment

Hiding Execl Window

Restoring the Excel Window

AutoOpen and AutoClose macros

 

Using VBA references

 

Creating runtime applications and Add Ins

 

Running Access from VBA

Processing Access Recordsets

Triggereing Access Forms and Reports

 

Building a Function Library

Advantages of writing generic Functions

Open any workbook

Open all Workbooks

Calculate a person’s age

Manipulate string data

 

Class Modules

Why Use Class Modules?

How Class Modules Work

A Simple Example: A Text File Class