Visual Basic for Applications (VBA) in Excel (intermediate level)

Course is intended for those familiar the basics of VBA who want to develop their knowledge and greater use of language capabilities.

Facilities

• Create your own toolbar and menu

The data types

• Conversion to other types
• The extent and lifetime of variables
• Operators and their priorities
• Options modules

Conditional statements

• Select Case
• If ... Then ... ElseIf ... Else

Loops

• When reversing loops
• For Each loop
• Instructions loop break (exit)

Debugging

• Processing step
• Traps Watches
• Locals Window
• Immediate Window
• Call Stack

Error handling

• Capturing and handling run-time errors
• Structures: On Error Resume Next, On Error GoTo label, On Error GoTo 0
• Data display on the statusbar

Basic optimization

• ScreenUpdating
• Measurement of the duration of the macro by the method Timer

VBA Forms

• Create your own forms
• Calling a form from the code
• Use the forms in the spreadsheet