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 (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
