Course Overview

Excel VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft — you know, the company run by the richest man in the world. Excel, along with the other members of Microsoft Office 2003, includes the VBA language (at no extra charge). In a nutshell, VBA is the tool that people use to develop programs that control Excel.

For example, you might create a VBA program to format and print your month-end sales report. After developing and testing the program, you can execute the macro with a single command, causing Excel to automatically perform many time-consuming procedures.

Course Outline

1. Excel VBA Object Model
2. The protection sheet from Excel VBA
3. Object Workbook, Workbooks collection
4. Worksheet Object, Collection Worksheets
5. Validation sheets
6. Practical methods of the Range object
7. Copy, paste, paste special
8. Property Current Region
9. Find, replace
10. Sorting ranges
11. Charts (Object Chart)
12. Events
13. Application-level events
14. Boards
15. Dynamic arrays
16. Table arrays Variant
17. Optimizing arrays and memory
18. Multi-dimensional arrays
19. Object-Oriented Programming
20. Classes and Objects
21. Creating classes
22. Creating and Destroying Objects
23. Create methods
24. Create property
25. Validation data using property
26. The default properties and methods
27. Error handling in the classroom
28. Create and manage collections
29. Create a collection
30. Adding and removing items
31. References to the components (using a key and an index)