Articles → VBA FOR EXCEL → What Is VBA
What Is VBA
- What is VBA?
- Why should I use it?
What Is VBA?
Why Should I Use It?
- Automation - If you want to automate any repetitive or frequently performed task in office applications then VBA is the right choice for you.
- Custom functionality – Microsoft has already provided numerous features and functionalities in office applications, but sometime it is required to customize some functionality based on the user needs. With VBA, we can achieve it.
- Communication between different office application – Consider a scenario where you want two office applications to talk to each other like copying outlook contents to excel. VBA is another option (apart from tedious and error prone manual approach) from which you can achieve this functionality.
- Extending the user interaction – If you want to extend the user experience like adding a button, textbox in the office application or change the color on any action or prompt an alert on any action. All these tasks could be done using VBA.