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

Facilities

• Create your own toolbar and menu

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

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

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

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

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

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

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