Course Outline
Macros
- Recording and editing macros
- Assigning macros to forms, toolbars, and keyboard shortcuts
VBA Environment
- Visual Basic Editor and its options
- Management components
- Keyboard Shortcuts
- Optimizing the environment
Introduction to Procedural Programming
- Procedures: Function Sub
- Data types
- The if statement ... then ... elseif ... else ... end if
- Case statement
- Loops for ... loop while, until
- Loop for ... next
- Instructions to break loops (exit)
- Array processing
Quoted Strings
- Combining quoted strings (concatenation)
- Conversion to other types (implicit and explicit)
- Processing features of quoted strings
Visual Basic
- Downloading and uploading data to a spreadsheet (Cells, Range)
- Downloading and uploading data with the user (InputBox, MsgBox)
- Variable declaration
- Scope and lifetime of variables
- Operators and their priorities
- Option modules
- Create your own functions and use them in a sheet
- Objects, classes, methods, and properties
- Securing code
- Security code tampering and preview
Debugging
- Step processing
- Locals window
- Immediate window
- Traps - Watches
- Call Stack
Error Handling
- Types of errors and ways to avoid them
- Capturing and handling run-time errors
- Structures: On Error Resume Next, On Error GoTo
Excel Object Model
- The Application Object
- Workbook object and a collection of Workbooks
- Worksheet Object and Collection Worksheets
- Objects ThisWorkbook, ActiveWorkbook, ActiveCell
- Object Selection
- Collection Range
- Object Cells
- Display data on the status bar
- Optimization using ScreenUpdating
- Time measurement by the Timer method
Event Handling in VBA
- What is an event?
- Responding to an event and creating an event handler
- Triggering Event Handlers
- Service frequently occurring events
VBA Forms
- Create your own forms
- Calling a form from code
- Use the forms in the sheet
Requirements
- Ability to work with spreadsheets and basic knowledge (including references, ranges, sheets, etc.).
- Previous VBA background is not required to create macros or 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 4800 € + 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.
