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
The outline below provides a suggested list of topics to be discussed during the training. The final curriculum may vary from the topics presented here, depending on the participants' experience, expectations, and needs.
Macros
- Recording and Modifying Macros
- Assigning Macros to Toolbars, Buttons, or Shortcut Keys
Visual Basic for Applications Environment
- Visual Basic Editor and its Settings
- Component Management
- Useful Shortcuts
- Optimizing the Environment
Introduction to Procedural Programming
- Procedures: Functions and Subroutines
- Data Types
Control Flow
- If ... Then ... ElseIf ... Else ... End If
- Select Case
- Do...Loop, While
- For...Next
- Exit Statements
- Arrays and Loops
- String Manipulation
Visual Basic
- VBA and Worksheet Data Exchange (Cells, Range Methods)
- Interacting with Users: InputBox and MsgBox
- Variable Declaration
- Variable and Object Scope and Lifetime
- Operators and Precedence
- Module Settings
- Creating Custom Worksheet Functions
- Understanding Objects, Classes, Methods, and Properties
- Protecting the Project from Viewing
Debugging
- Run Time, Design Time, and Break Mode
- Breakpoints and Watches
- Local Window
- Immediate Window
- Call Stack
Error Handling
- Error Types
- On Error GoTo
- On Error Resume Next
Event Handling in VBA
VBA User Forms
- Creating and Using User Forms
- Launching User Forms via VBA Code
- Integrating VBA User Forms into Worksheets
Requirements
- General computer literacy
- Familiarity with any operating system
7 Hours
Testimonials (4)
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Visual Basic for Applications (VBA) w Excel - wstęp do programowania
Well structured. Good teaching techniques. Course well documented!
Sorin
Course - VBA For Access & Excel
What I liked most about the training was the trainer’s knowledge of Excel. I appreciated learning useful things like shortcuts and formulas that I can use every day.
Martin
Course - Visual Basic for Applications (VBA) for Analysts
Very practical
