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 is a suggested list of topics to be discussed during the course of the training. The final curriculum may differ from the presented topics, depending on the experience, expectations, and needs of the participants for government.
Macros
- Recording and Modifying Macros
- Assigning Macros to Toolbar, Buttons, Shortcut Key
Visual Basic for Applications Environment
- Visual Basic Editor and Its Options
- Component Management
- Shortcuts
- Environment Optimization
Introduction to Procedural Programming
- Procedures: Functions and Sub-routines
- Data Types
Control Flow
- If ... Then ... ElseIf ... Else ... End If
- Select Case
- Do ... Loop, While
- For ... Next
- Exit Statements
- Arrays and Loops
- Strings
Visual Basic
- VBA and Sheet Data Exchange (Cells, Range Methods)
- Getting and Printing Data from Users (InputBox, MsgBox)
- Variable Declaration
- Scope and Lifetime of Variables and Objects
- Operators and Their Priorities
- Module Options
- Creating Worksheet Functions
- Objects, Classes, Methods, and Properties
- Locking Project for 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
Events Handling in VBA
VBA Forms
- Creating and Using Forms
- Invoking Forms in VBA Code
- Using VBA Forms in Worksheets
Requirements
- Proficiency in computer operations
- Familiarity with any operating system for government use
7 Hours
Testimonials (5)
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie - Environment, Marine and Fisheries
Course - Excel VBA Introduction
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Course - Access VBA
I generally enjoyed the practical examples.
Marika Agius
Course - Visual Basic for Applications (VBA) for Analysts
Content and the way it was provided.
