About VBA
VBA is a language that is used to automate the Microsoft Office Applications i.e. MS-Excel, MS-Access, MS-Word etc. Here we only deal with VBA for Excel not with any other Microsoft Application. You will find out many different examples to automate the Excel Workbook/worksheet. Excel workbook can be automated in number of ways like formatting(depending upon different criteria), extracting data from external databases, report samples depending on the user requirements. Main rationale behind VBA is to save time in day to day operations. Any action or work we perform in Excel can be automated and done within second/seconds using VBA.

Importance of VBA

Reduce cost associated with Business Operations by saving time
Helps to perform Business Operation in more efficient way
Add Interactive functionality into Excel for End Users