VBA Programming


Cut manual work and build powerful, advanced Excel and Access applications using VBA

VBA allows powerful, custom applications to be created easily, with off-the-shelf software, without learning a lot of program code. It supports industry standard office software elements, including databases, spreadsheets, forms, Active X controls, and web pages. It is relatively fast, and more forgiving than rigid programming languages. Supercharge and automate your Excel and Access work with custom menus and dialog boxes, one-click task execution, and use of powerful built in calculation, search and query functions. 

Three courses to fit your needs:
- Advanced VBA for Access
- Advanced VBA for Excel
- General VBA programming- all apps

VBA topics
What is VBA? 
The Use of VBA in Applications 
VBA Macro Features - VBA Versus Visual Basic, Visual Basic Editor 
The Difference between VBA and Visual Basic 
The Visual Basic Editor
 - The Project Explorer
 - The Properties Window
 - The Work Area 
VBA Applications Development Launching VBA 
VBA Modules in Excel 
Creating a New VBA Module 
Working with Procedures
 - The Structure of a Procedure
 - Calling a Procedure
 - Public versus Private Procedures 
VBA Variables - Data Types, Declaration, Arrays 
Declaring Variables 
Understanding Variable Scope
 - Procedure-Level Scope
 - Module-Level Scope
 - Public Scope 
Passing Variables as Arguments 
Variable Data Types 
Using Array Variables
 - Declaring Arrays
 - Multidimensional Arrays 
Working with Constants
 - Using Built-In Constants
 - Creating User-Defined Constants 
VBA Expressions and Operators 
Understanding Expression Structure 
VBA
 - Arithmetic Operators
 - The Concatenation Operator
 - Comparison Operators
 - Logical Operators 
Working with Expressions
 - Numeric Expressions
 - String Expressions
 - Logical Expressions
 - Date Expressions 
VBA Objects and Collections 
Understanding Objects 
The Object Hierarchy 
Working with Objects Properties
 - Setting the Value of a Property
 - Returning the Value of a Property 
Working with Object Methods 
Handling Object Events 
Working with Object Collections 
The Application Object
 - Properties of the Application Object
 - Methods of the Application Object 
VBA Control Structure - Branching, Iteration 
Code that Makes Decisions
 - Using If ... Then Statements
 - Using If ... Then ... Else Statements
- Using the Select Case Statement
 - Using Do ... Loop Structures
 - Using For ... Next Loops
 - Using For Each ... Next Loops
 - Using Exit For or Exit Do to Exit a Loop 
VBA Application Examples - Models in Word, Excel, and Access

Mark "Doc" Noel (c) 2002
Contact: 386-446-5522
e-mail: wicketkeeper@rocketmail.com