Visual Basic for Applications (VBA) in Excel - Introduction to programming

Macros

• Recording and editing macros
• Assigning macros to forms, toolbars, keyboard shortcuts

• Visual Basic Editor and its options
• Management components
• Keyboard Shortcuts
• Optimizing the environment

• Procedures: Function Sub
• Data types
• The if statement ... then ... elseif ... else ... end if
• Case statement
• Loops for ... loop while, until
• Loop for ... next
• Instructions loop break (exit)
• Array processing

• Combining quoted strings (concatenation)
• Conversion to other types of (implicit and explicit)
• Features processing quoted strings

• Download and upload data to a spreadsheet (Cells, Range)
• Download and upload data to the user (InputBox, MsgBox)
• The declaration of variables
• The extent and lifetime of variables
• Operators and their priorities
• Options modules
• Create your own functions and use them in a sheet
• Objects, classes, methods and properties
• Securing code
• Security code tampering and preview

• Processing step
• Locals window
• Immediate window
• Traps - Watches
• Call Stack

• Types of errors and ways to avoid
• Capturing and handling run-time errors
• Structures: On Error Resume Next, On Error GoTo

• The Application Object
• Workbook object and a collection of Workbooks
• Worksheet Object and Collection Worksheets
• Objects ThisWorkbook, ActiveWorkbook, ActiveCell
• Object Selection
• Collection Range
• Object Cells
• Display data on the status bar
• Optimization using ScreenUpdating
• The time measurement by the method Timer

• What is an event?
• Responding to an event and create an event handler
• Triggering Event Handlers
• Service frequently occurring events

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