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

Macros

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

VBA Environment

• The Visual Basic Editor and its configuration options
• Managing components
• Keyboard shortcuts
• Optimizing the development environment

Introduction to Procedural Programming

• Procedures: Function and Sub
• Data types
• Conditional logic: if ... then ... elseif ... else ... end if
• Case statements
• Loops: for ... loop while, until
• Loops: for ... next
• Loop control: break (exit)
• Array manipulation

String Handling

• Combining strings (concatenation)
• Type conversion (implicit and explicit)
• Processing string features

Visual Basic

• Reading and writing data to spreadsheets (Cells, Range)
• Interacting with users (InputBox, MsgBox)
• Variable declaration
• Variable scope and lifetime
• Operators and precedence
• Module options
• Creating and utilizing custom functions within sheets
• Objects, classes, methods, and properties
• Securing code
• Preventing code tampering and previewing security

Debugging

• Step-through processing
• Locals window
• Immediate window
• Breakpoints and Watches
• Call Stack

Error Handling

• Identifying error types and prevention strategies
• Capturing and managing runtime errors
• Structures: On Error Resume Next, On Error GoTo

Excel Object Model

• The Application Object
• Workbook object and Workbooks collection
• Worksheet Object and Worksheets Collection
• ThisWorkbook, ActiveWorkbook, and ActiveCell objects
• Selection object
• Range collection
• Cells object
• Displaying data on the status bar
• Optimization via ScreenUpdating
• Timing measurement using the Timer method

Event Handling in VBA

• Understanding events
• Responding to events and creating handlers
• Triggering event handlers
• Handling common events

VBA Forms

• Building custom forms
• Invoking forms from code
• Utilizing forms within sheets