t 01732 833085
e david wallis
:: home > excel training > excel vba programming course
excel VBA programming course
This is a course for Excel developers who want an appreciation of the Excel version of VBA (Visual Basic for Applications) and its use in enhancing spreadsheet operability.
It will suit anyone who has been recording macros and now wants to gain more control over automation of their spreadsheets than recording alone provides.
course duration
Two days on-site.
course pre-requisites
Skills in using Excel to a level that would be achieved by completing our Intermediate and Advanced Excel training courses.
course content
Topics may include the following and you can specify others to suit your objectives.
recording macros
Why and when to record
Editing recorded macros
excel VBA
Using the Visual Basic Editor
VBA syntax
VBA help
Projects
Modules
Objects and object hierarchy.
procedures and functions
Sub procedures
Function procedures
Calling procedures
Use of Immediate Window to test code
Organizing code and procedures.
references
Relevance of references
Managing References.
working on properties
Distinguishing Properties
Influencing properties
Using With...End With statements.
working with methods
Distinguishing Methods
Applying methods.
coding
Expressions
Statements.
variables and constants
Declaring variables
Variable data types
Variable scope and lifetime
Local and global constants.
functions
Creating a function
Using a function
capturing user input
Message boxes
Input boxes
Custom dialog boxes.
program execution control
Program flow
Boolean expressions
If...Else...End statements
Select Case...End Select statements
For...Next statements
For Each...Next statements
Do...Loop statements.
range object
Addressing cells
The active cell
Range offsets
Doing things to cells
Doing things with cells.
worksheets and workbooks
Addressing worksheets
Addressing workbooks.
toolbars
Creating toolbars using VBA.
debugging code
Understanding Errors
Using debugging tools
Testing and evaluating expressions.
error handling
Purpose of error handling
Essential error handling
VBA error object
Trapping and responding to errors
General-purpose error-handling code.
london, kent, surrey, east sussex, west sussex
We regularly travel to clients in London and the South East. Based near Tonbridge, we are particularly well placed to visit clients throughout Kent, East and West Sussex, Surrey and London.
As we have done in Ashford, Aylesford, Brighton, Canterbury, Chatham, Chiddingstone, East Grinstead, Edenbridge, Heathfield, Lightwater, London, Maidstone, Maresfield, Orpington, Paddock Wood, Richmond, Rochester, Sevenoaks, Sittingbourne, Tadworth, Ticehurst, Tonbridge, Tunbridge Wells and Westerham.