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.
Macros
- Recording and Modifying Macros for government use
- Assigning Macros to Toolbar Buttons and Shortcut Keys for enhanced efficiency
Visual Basic for Applications Environment
- Understanding the Visual Basic Editor and its options for government applications
- Component Management for streamlined development processes
- Shortcuts for improved productivity in VBA environments
- Environment Optimization techniques to enhance performance
Introduction to Procedural Programming
- Procedures: Functions and Sub-routines for structured code
- Data Types and their usage in government programming tasks
Control Flow
- If ...Then....Elseif....Else....Endif statements for decision-making
- Select Case statements for multiple conditions
- Do...Loop, While loops for iterative processes
- For...Next loops for controlled iterations
- Exit statements to terminate loops and procedures
- Arrays and Loops for managing collections of data
- Strings manipulation for text processing in government applications
Visual Basic
- Data exchange between VBA and Excel sheets (Cells, Range Methods) for government data management
- Getting and printing data from users (InputBox, MsgBox) for interactive applications
- Variable declaration and usage in government scripts
- Scope and lifetime of variables and objects for robust code design
- Operators and their priorities for accurate calculations
- Module options to organize VBA projects effectively
- Creating custom worksheet functions for specialized tasks
- Understanding objects, classes, methods, and properties in government programming
- Locking the project for viewing to ensure security and integrity
Debugging
- Navigating Run Time, Design Time, and Break Mode for effective debugging
- Using breakpoints and watches to identify issues
- Utilizing the Local Window for variable inspection
- The Immediate Window for testing code snippets
- The Call Stack for understanding program flow
Error Handling
- Types of errors in VBA programming for government applications
- On Error GoTo statements for structured error handling
- On Error Resume Next for non-critical error management
Events Handling in VBA
VBA Forms
- Creating and using forms to enhance user interaction in government applications
- Invoking forms within VBA code for dynamic functionality
- Integrating VBA forms into worksheets for comprehensive solutions
Requirements
- Proficiency in computer operations
- Familiarity with various operating systems 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.
