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 configuration options
- Management components
- Keyboard Shortcuts
- Optimising 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
- Loop break instructions (exit)
- Array processing
Quoted Strings
- Combining quoted strings (concatenation)
- Conversion to other types (implicit and explicit)
- Features for processing quoted strings
Visual Basic
- Downloading and uploading data to a spreadsheet (Cells, Range)
- Downloading and uploading data to the user (InputBox, MsgBox)
- Variable declaration
- Variable scope and lifetime
- Operators and their priorities
- Module options
- Creating custom functions and using them in a sheet
- Objects, classes, methods, and properties
- Securing code
- Preventing code tampering and previewing code
Debugging
- Step-by-step processing
- Locals window
- Immediate window
- Traps - Watches
- Call Stack
Error Handling
- Types of errors and methods 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 the Workbooks collection
- Worksheet Object and the Worksheets collection
- Objects: ThisWorkbook, ActiveWorkbook, ActiveCell
- Object Selection
- Range collection
- Cells object
- Displaying data on the status bar
- Optimisation using ScreenUpdating
- Time measurement via the Timer method
Event Handling in VBA
- Understanding events
- Responding to an event and creating an event handler
- Triggering Event Handlers
- Managing frequently occurring events
VBA Forms
- Creating custom forms
- Calling a form from code
- Utilising forms within a sheet
Requirements
- Ability to work with spreadsheets and possess basic knowledge (including references, ranges, sheets, etc.).
- No prior VBA background knowledge is required to create macros or write VBA code.
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.
