1 | Exposure to the entire suite of Microsoft Office Objects : Each Office application exposes its functionality as a set of programmable objects. VBA makes it possible to access these objects and manipulate them to suit the need of the application. |
2 | |
3 | Consistent syntax across applications : VBA makes it possible to use BASIC-like code syntax across the entire suite of Office applications eliminating the need to learn a new language to use a different application. |
4 | |
5 | Ability to use Active-X Controls: VBA supports the use of a powerful new software development medium called Active-X Control. These are reusable software components which are pre-built to function as individual modules carrying out a specific task. They are like manufactured spare parts ready to be plugged into the cars on the assembly-line. |