Visual basic for Excel

What will be covered on this three-day workshop?
Module one
What is VBA?

Understanding VBA and Visual Basic
What is object orientated programming
Macros and VBA

Module two
Macros
Using macros
Recording macros
Running macros
Adding macro buttons to the toolbar
Update records
Run a report

Module three
The visual basic editor
VBE environment
The project explorer
The properties window
The structure of visual basic code
Viewing the code created by macros

Module four
Creating subroutines
Creating code
Working with Excel's objects
Using methods
Using object properties

Module five
Decision making

Using IF statements
Using Else and ElseIf statements
Using select case statements

Module six
Loops

Using loops to repeat code
Do loop
For next loops

Module seven
Reviewing your code
Runtime errors
Compile errors
Testing your code
Debugging code
Using error handlers

Module eight
Functions
Creating functions
Referencing functions
Using functions in Excel

Module nine
User forms
Creating user forms
The properties window
Adding components to a form
Using a naming convention
Adding code to a form

Date: 16 February 2016 to 18 February 2016
Time: 09:00 - 16:30
Venue: Benvenuto Conference Centre in Randburg, Randburg
Cost: R7,050 excl. vat

Date: 16 March 2016 to 18 March 2016
Time: 09:00 - 16:30
Venue: Birchwood Hotel and OR Tambo Conference Centre, Boksburg
Cost: R7,050 excl. vat

Date: 18 May 2016 to 20 May 2016
Time: 09:00 - 16:30
Venue: Benvenuto Conference Centre, Randburg
Cost: R7,050 excl. vat

Date: 21 June 2016 to 23 June 2016
Time: 09:00 - 16:30
Venue: Birchwood Hotel & OR Tambo Conference Centre, Boksburg
Cost: R7,050 excl. vat