Excel VBA Training
|
This course allows experienced Excel users to enhance their solutions by writing macros with Visual Basic for Applications. The course length ranges from one day for an overview, 2 days for the most popular in-depth coverage, and 3 days to allow additional database work or to allow projects specific to your final goal to be completed. The 2 day course costs £1180 in total for up to 6 students, plus VAT and the instructor's reasonable expenses. Each student beyond 6 would cost £15 for the additional course materials. If you are interested in this course, please contact us by email at
enquiries@tgn.co.uk
or by phone on |
Introduction | Macros and the macro recorder. The concept of an 'object'. Properties, methods and events. Buttons. |
Getting Started with VBA | The Visual Basic editor. Writing macro subs. Calling macros. Introducing variables. Message and input boxes. |
The Visual Basic Language | Using Excel objects. Data types and conversions. If, Else and Select Case. Loops. Dates and times. |
Referencing Cells and Objects | Referencing cells in a worksheet. Range and cells. Complex ranges. Offsets. Collections and accessor methods. Adding to a collection. Workbooks and worksheets. Dealing with selections. Charts. Responding to events. |
Further Visual Basic | Variable scope. Arrays. Functions. Using a function on a worksheet. Error handling. |
User Forms | UserForms - custom dialogs. The toolbox. Showing forms. Handling events for a form. Closing a form. Using properties. Combo boxes. Interaction. |
Databases and ADO | Active Data Objects - ADO. Connection strings. Recordsets. Reading column values. |
Creating an Add-In | Project properties. Protection. Creating an Add-In. Using an Add-In. |
Copyright © 1996 - 2010 The Graphics Network Ltd. Registered in England No. 2549085
All trademarks used on this site are respectfully acknowledged.
Microsoft is a registered trademark of Microsoft Corporation in the United States and other countries.