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

Macros

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

VBA Environment

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

Introduction to Procedural Programming

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

String Handling

• Concatenating strings
• Converting to other data types (implicit and explicit)
• Techniques for processing strings

Visual Basic

• Transferring data to and from spreadsheets (Cells, Range)
• Exchanging data with the user (InputBox, MsgBox)
• Variable declarations
• Variable scope and lifetime
• Operators and their precedence
• Module options
• Creating custom functions and utilizing them within sheets
• Objects, classes, methods, and properties
• Code security
• Protecting code from tampering and previewing

Debugging

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

Error Handling

• Types of errors and prevention strategies
• Catching and handling run-time errors
• Error handling structures: On Error Resume Next, On Error GoTo

Excel Object Model

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

Event Handling in VBA

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

VBA Forms

• Creating custom forms
• Invoking forms from code
• Integrating forms into sheets