What is VBA?
This is a Object-Oriented Programming language from the family of Visual basics but for Microsoft Applications. Note that VBA is different than VB Script or VB, .Net.
Since VBA is for applications, VBA for Excel is slightly different than VB for Word or VB for Outlook or VB for Powerpoint or VB for Visio.
Don't worry! If you know VBA for Excel you will not have any problem with VB for other applications.
Remember VBA is a very powerful tool which provides unbelievable capabilities to excel users.
The fundamental idea behind VBA is to automate manual labor. Once my manager(Rahul Ramineni) said something like, he likes to automate something because he is very lazy. I don't agree with him all 100% but yeah it is true more or less.
Imagine if you can automate the process of collecting data from your Team members, store it on common sheet, modify some of the values if they are left blank, format it , draw a chart and sent the report to your manager.
Yes! you can do all that using Excel. Have you ever wondered if you can have the error messages on a form to be funny. Well I have! I always wanted to have those error message funny and the way I like it. Yes you can do that using VBA.
No comments:
Post a Comment