Back to Home Page
I want to:
What is VBA?
VBA is an acronym for Visual Basic for Applications. This is a programming language used by Microsoft Applications such as Access, Excel, Word, etc.
VBA has“dialects” which are slightly different for each of the Applications. The common ground is dealt with in the VBA Introduction manual, which should be treated as a pre-requisite for the specific manuals for the Applications. 
What is in the course?
VBA General Introduction
- Getting Started
- Security
- Using the VBA Editor
- Variables
- Interactions With The User
- Making Decisions
- Looping
- Error Handling
Detailed Outlines
- Full Outline
Excel VBA
Level 1
- The Personal Macro Workbook
- Excel Objects
- Common VBA Techniques
- User Functions
- User Forms
Level 2
- Charts
- Pivot Tables
- Sort, Filter and Export to Other Formats
- Output to Outlook
- Connect to External Databases
- Form and ActiveX Controls
Detailed Outlines
Level 1 Full Outline
Level 2 Full Outline
Access VBA
- Class and Standard Modules
- Access Objects
- ADO
- Common VBA Techniques
- Other Applications
Detailed Outlines
- Full Outline
Exercise File Downloads
Please click on the button below to download the Zipped files. The download contains all files for Excel, Access and Introduction topics.
Then check in your Downloads folder. You will need to remove the files from the Zip file in order to use them
