Intorduction to Macro and Visual Basic Application

Learning Outcomes

After completing this course, the student will be able to: Complete Task Automation with Macros; Create Macro for Task Automation; Selects Control Properly; Run Macro from Control and Custom Toolbar; Explain How Macro Works in Ms Excel

Topics

1. Introduction
2. Formatting with Macros
3. Running Complex Formula with Macros
4. Import and Export File with Macros
5. Database Function with Macros
6. Macro Protection
7. Combining Macros
8. Spin Button and Scroll Bar
9. Check Box and Option Button
10. Combo Box and List Box
11. Text Box and Calendar Control
12. Select and Combine Controls
13. Task Automation and Macro/VBA