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 options
- Component management
- Keyboard shortcuts
- Optimising the development environment
Introduction to Procedural Programming
- Procedures: Functions and sub-routines
- Data types
Control Flow
- If... Then... ElseIf... Else... End If
- Select Case
- Do... Loop and While loops
- For... Next loops
- Exit statements
- Arrays and loops
- String manipulation
Visual Basic
- VBA and worksheet data exchange (Cells, Range methods)
- Gathering and displaying data from users (InputBox, MsgBox)
- Variable declaration
- Scope and lifetime of variables and objects
- Operators and their precedence
- Module options
- Creating worksheet functions
- Objects, classes, methods, and properties
- Locking projects for viewing
Debugging
- Run time, design time, and break mode
- Breakpoints and watches
- The Locals window
- The Immediate window
- Call stack
Error Handling
- Types of errors
- On Error GoTo
- On Error Resume Next
Excel Object Model
- The Application object
- The Workbook object and Workbooks collection
- The Worksheet object and Worksheets collection
- ThisWorkbook, ActiveWorkbook, ActiveCell, and more
- The Selection object
- The Range collection
- The Cells collection
- Using the status bar
- Screen updating and optimisation
- Timers and time measurement
Event Handling in VBA
VBA Forms
- Creating and using forms
- Invoking forms within VBA code
- Integrating VBA forms into worksheets
Requirements
- A good working knowledge of Excel.
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.
