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
- Conditional statements: if ... then ... elseif ... else ... end if
- Case statement
- Loops: for, while, until
- For ... next loops
- Loop control statements (exit)
- Array processing
Quoted string manipulation
- Combining quoted strings (concatenation)
- Type conversion (implicit and explicit)
- Key features for processing quoted strings
Visual Basic
- Reading and writing data to spreadsheets (Cells, Range)
- Data exchange with users via InputBox and MsgBox
- Variable declaration
- Variable scope and lifetime
- Operators and their precedence
- Option settings for modules
- Creating and using custom functions in sheets
- Objects, classes, methods, and properties
- Code security measures
- Preventing and previewing code tampering
Debugging
- Stepping through code
- Locals window
- Immediate window
- Traps and Watches
- Call Stack
Error handling
- Types of errors and prevention strategies
- Capturing and handling run-time errors
- Statements: On Error Resume Next, On Error GoTo
Excel Object Model
- The Application Object
- Workbook object and Workbook collections
- Worksheet Object and Worksheet collections
- ThisWorkbook, ActiveWorkbook, and ActiveCell objects
- Selection objects
- Range collections
- Cells objects
- 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
- Managing frequently occurring events
VBA Forms
- Creating custom forms
- Invoking forms from code
- Utilizing forms within worksheets
Requirements
- Proficiency in working with spreadsheets, including foundational knowledge of references, ranges, sheets, etc.
- No prior VBA experience is required to create macros or write VBA code.
Audience
- Data Analysts
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
