Price: AED 1,500

Duration: 24 Hours

Timing: Flexible

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)

Related Courses