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.
Duration 21 hours
Course Outline
Macros
- Documentation and modification of macros
- Association of macros with forms, toolbars, and keyboard shortcuts
VBA Environment
- Visual Basic Editor configuration and interface options
- Management components
- Keyboard shortcuts
- Optimization of the development environment
Introduction to procedural programming
- Procedures: Function and Sub definitions
- Data types
- Conditional logic: if ... then ... elseif ... else ... end if
- Case statement implementation
- Loop structures: for ... loop while, until
- Loop structures: for ... next
- Loop control instructions: break (exit)
- Array processing
Quoted string
- String concatenation methods
- Type conversion mechanisms (implicit and explicit)
- Processing features for quoted strings
Visual Basic
- Data exchange with spreadsheets (Cells, Range objects)
- User interface interactions (InputBox, MsgBox)
- Variable declaration standards
- Variable scope and lifecycle management
- Operator hierarchy and priority
- Module options configuration
- Development of custom functions for sheet integration
- Object-oriented concepts: objects, classes, methods, and properties
- Code security protocols
- Protection against code tampering and preview security
Debugging
- Step-by-step processing analysis
- Locals window utilization
- Immediate window operations
- Breakpoints and Watches
- Call Stack inspection
Error handling
- Error classification and prevention strategies
- Run-time error capture and management
- Control structures: On Error Resume Next, On Error GoTo
Excel Object Model
- The Application Object
- Workbook object and Workbooks collection management
- Worksheet Object and Worksheets collection management
- Core objects: ThisWorkbook, ActiveWorkbook, ActiveCell
- Selection object operations
- Range collection management
- Cells object manipulation
- Status bar data display
- Performance optimization via ScreenUpdating
- Time measurement using the Timer method
Event handling in VBA
- Definition of events
- Event response mechanisms and handler creation
- Execution of Event Handlers
- Handling of frequent system events
VBA Forms
- Development of custom forms
- Programmatic invocation of forms
- Integration of forms within spreadsheets
Requirements
- Proficiency in spreadsheet operations, including fundamental knowledge of references, ranges, and sheets
- Prior experience in VBA is not required for developing macros or VBA code
Audience
- Data Analysts
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.
