Course Duration
16 hours, 2-day training workshop
Delivery
Face to face training or online training
Course Inclusive
Training materials & certificate of completion
Course Content
- Module I: Recording Macros
- Exploring Macro Security
- Recording and Running a Macro
- Using Relative Reference
- Assigning a Macro to an Image or Button
- Module II: VBA Programming
- Essential VBA Codes
- Using IF in VBA
- Creating Loops and Other Decision Structures
- Interactive Elements
- Other Object Programming
- Module III: Functions
- Designing Own Functions
- Writing Formulas in VBA
- Using Excel Functions in VBA
- VBA Functions
- Module IV:Userforms
- Designing Userforms
- Adding Operations on UserformÂ
- Module V: Creating Module
- Design Strategies
- Error Handling