Certificate for Hubert Wierzbicki

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