Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Macros
- Recording and modifying macros
- Assigning macros to toolbars, buttons, and shortcut keys
Visual Basic for Applications Environment
- The Visual Basic Editor and its settings
- Component management
- Keyboard shortcuts
- Optimizing the development environment
Introduction to Procedural Programming
- Procedures: Functions and Subroutines
- Data types
Control Flow
- If...Then...ElseIf...Else...End If statements
- Select Case statements
- Do...Loop and While loops
- For...Next loops
- Exit statements
- Arrays and loops
- String manipulation
Visual Basic
- Interacting with sheet data (Cells and Range methods)
- Input and output via user interfaces (InputBox and MsgBox)
- Variable declaration
- Variable and object scope and lifetime
- Operators and precedence
- Module options
- Creating user-defined worksheet functions
- Objects, classes, methods, and properties
- Locking the project for viewing
Debugging
- Runtime, design time, and break mode
- Breakpoints and watch windows
- The Locals window
- The Immediate window
- The Call Stack
Error Handling
- Error types
- On Error GoTo
- On Error Resume Next
Excel Object Model
- The Application object
- Workbook objects and the Workbooks collection
- Worksheet objects and the Worksheets collection
- ThisWorkbook, ActiveWorkbook, ActiveCell, etc.
- The Selection object
- The Range collection
- The Cells collection
- Utilizing the status bar
- Screen updating and optimization techniques
- Timer usage and time measurement
Event Handling in VBA
VBA Forms
- Creating and utilizing forms
- Invoking forms via VBA code
- Integrating VBA forms into worksheets
Requirements
- Proficient knowledge of Excel.
Target Audience
- Data Analysts
14 Hours
Testimonials (1)
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
