Microsoft Excel VBA Training Courses

Arrays and Loops
• Introduction to arrays
• Loop types
• Do until and do while loops
• For next loop
• For each loops with collections
• Choosing the correct loop for repeated tasks

Decision Structures in VBA
• Using IF to make decisions
• Testing for multiple conditions
• Using Select CASE
• Call other procedures

Debugging and working with multiple macros
• Debugging Features in VBA
• Calling one Macro from Another

VBA Functions
• Creating Custom Excel Functions in VBA
• Using user-defined Functions in a worksheet
• Using Custom Functions in Macros
• Decision making with Select Case
• Declaring multiple arguments in a function
• Distributing functions

Error Handling & Tables
• Error Handling in VBA
• Finding the extend of data in a Spreadsheet
• Introduction to Using Excel Tables in VBA

Working with Forms
• Introduction to the VBA User Form Editor
• Creating a Custom Dialogue box with a User Form
• Creating a user form
• Adding form controls
• Setting properites for the form and controls
• Creating the event code for controls
• Initialising the form
• Closing the form

Workbooks and Worksheets
• Workbook objects and methods
• Creating a new workbook
• Saving and closing a workbook
• Adding and renaming sheets
• Using the cells property to select a range
• Using the offset property to refer to a range
• Using the columns and rows properties to specify a range
• Using the currentregion property to select a range

Error Handling
• Stepping through a procedure
• Using a break point
• The On Error Statement
• On Error GoTo
• The Resume

Introduction to Excel Macros and VBA
Recording macros
Running macros
Reviewing the code,
Familiarisation with the VBA environment
Running code from the VBE, Getting help

VBA Terminology
Modules and procedures
Components of your code
Objects
Collections
Properties
Methods

Programing Standards
Code format
Naming conventions
Procedural structure

Data Types, Variables and Operators
Working with variables
Using data types
Working with operators and expressions

Workbooks and Worksheets
Adding worksheets in the VBA code
Naming and renaming worksheets

Decision Structures in VBA
Using If to make decisions
Using select case

Loops
Do until and Do while stop Loops
Fur next Loop