Excel VBA courses London & UK

Introducing Visual Basic
Overview of Visual Basic for Applications
Using Macros
Using Visual Basic editor to edit macros
Examining the development environment
Visual Basic help
Closing the editor

Using Procedures and Functions
Understanding and creating modules
Examining procedures
Making a sub procedure
Calling procedures and using the immediate window
Function procedures
Naming a procedure
Using the code editor

Examining Objects
Introducing objects
Understanding the Excel object hierarchy
Examining collections
The object browser
How to work with properties
The with statement
Understanding methods
Designing an event procedure

Expressions, Variables and Intrinsic Functions
Examining expressions and statements
How to declare variables
Examining data types
How to work with variable scope
Creating with intrinsic functions
Examining constants
Creating with intrinsic constants
Creating with message boxes
Creating with input boxes
How to declare and use object variables

Mastering Program Execution
Explaining control-of-flow structures
Adapting boolean expressions
Inputting the if...end if decision structures
Inputting the select case...end select structure
Inputting the do...loop structure
Inputting the for...next structure
Inputting the for each...next structure
Mapping the use of control-of-flow structures

Using Forms and Controls
Examining UserForms
How to use the toolbox
Understanding UserForm properties, events and methods
Explaining controls
Determining control properties in the properties window
How to work with the label control
How to work with the text box control
How to work with the command button control
How to work with the combo box control
How to work with the frame control
How to work with option button controls
How to work with control appearance
Designating the tab order
How to populate a control
Incrementing code to controls
Uploading a form in code

Harnessing the PivotTable Object
Examining PivotTables
Designing a PivotTable
How to work with the PivotTable wizard method
How to work with PivotFields
Directing a procedure to a custom toolbar

Debugging Code
Explaining errors
Uses of debugging tools
How to set breakpoints
Staging through code
How to use break mode during run mode
Analysing the value of expressions

Error Handling
Examining error handling
Explaining VBA's error trapping options
Using the on error statement to trap errors
Examining the error object
Creating an error handling routine
Building with inline error handling