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 options.
- Management components.
- Keyboard shortcuts.
- Optimising the environment.
Introduction to Procedural Programming
- Procedures: Function and Sub.
- Data types.
- The If statement: If...Then...ElseIf...Else...End If.
- Select Case statement.
- Loops: For...Loop, While...Loop, Until...Loop.
- For...Next loop.
- Loop exit instructions (Exit).
- Array processing.
String Literals
- Combining string literals (concatenation).
- Conversion to other data types (implicit and explicit).
- Processing string literals.
Visual Basic
- Reading and writing data to worksheets (Cells, Range).
- Interacting with users (InputBox, MsgBox).
- Variable declaration.
- Scope and lifetime of variables.
- Operators and their precedence.
- Module options.
- Creating and using custom functions in worksheets.
- Objects, classes, methods, and properties.
- Securing code.
- Preventing code tampering and previewing security settings.
Debugging
- Step-by-step execution.
- Locals window.
- Immediate window.
- Breakpoints and watches.
- Call stack.
Error Handling
- Types of errors and how to avoid them.
- Capturing and handling runtime 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.
- ThisWorkbook, ActiveWorkbook, and ActiveCell objects.
- Object selection.
- Range collection.
- Cells object.
- Displaying data on the status bar.
- Optimisation using ScreenUpdating.
- Time measurement using the Timer method.
Event Handling in VBA
- What is an event?
- Responding to events and creating event handlers.
- Triggering event handlers.
- Handling frequently occurring events.
VBA Forms
- Creating custom forms.
- Calling a form from code.
- Using forms within worksheets.
Requirements
- Ability to work with spreadsheets, including basic knowledge of references, ranges, and sheets.
- No prior VBA experience 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.
