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 editing macros
- Assigning macros to forms, toolbars, and keyboard shortcuts
VBA Environment
- Visual Basic Editor and its settings
- Management components
- Keyboard Shortcuts
- Optimizing the development environment
Introduction to Procedural Programming
- Procedures: Function and Sub
- Data types
- If statements (Then ... ElseIf ... Else ... End If)
- Case statements
- Loops: For, While, Until
- For ... Next loops
- Exit instructions for loops
- Array processing
Working with Strings
- Concatenating strings
- Conversion to other data types (implicit and explicit)
- String manipulation features
Visual Basic Essentials
- Reading and writing data to spreadsheets (Cells, Range)
- User interaction via InputBox and MsgBox
- Variable declaration
- Variable scope and lifetime
- Operators and precedence
- Module options
- Creating and using custom functions in worksheets
- Understanding objects, classes, methods, and properties
- Code security best practices
- Preventing code tampering and enabling preview
Debugging Techniques
- Step-by-step execution
- Using the Locals window
- Using the Immediate window
- Watchpoints
- Call Stack analysis
Error Handling
- Types of errors and prevention strategies
- Capturing and managing run-time errors
- Structures: On Error Resume Next, On Error GoTo
The Excel Object Model
- The Application Object
- Workbook object and Workbooks collection
- Worksheet object and Worksheets collection
- Objects: ThisWorkbook, ActiveWorkbook, ActiveCell
- Selection objects
- Range collection
- Cells object
- Displaying data on the status bar
- Optimizing performance with ScreenUpdating
- Measuring time using the Timer method
Event Handling in VBA
- Understanding events
- Creating and responding to event handlers
- Triggering event handlers
- Managing frequently occurring events
VBA User Forms
- Creating custom forms
- Invoking forms from code
- Integrating forms into worksheets
Requirements
- Familiarity with spreadsheet operations, including basic knowledge of references, ranges, and sheets.
- No prior VBA programming experience is required to create macros or write VBA code.
Target Audience
- Data Analysts
21 Hours
Testimonials (5)
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Visual Basic for Applications (VBA) w Excel - wstęp do programowania
A lot of exercise. Trainer doesn't need to have support for his course. He has really great knowledge for his subject.
Quentin Demeyere
Course - Visual Basic for Applications (VBA) in Excel - Introduction to programming
It was really nice of the trainer that he took a lot of time to answer our questions and helped us improve or gave us hints on how to improve some macros we were already using without fully understanding the code.
David Trieu - CD Projekt SA
Course - Visual Basic for Applications (VBA) in Excel - Introduction to programming
I genuinely enjoyed the short exercises.
Mateusz Podsiadlo
Course - Visual Basic for Applications (VBA) in Excel - Introduction to programming
Training agenda was well thought out.
