The 4 main purposes of learning VBA are to

1. automate repetitive tasks and reduce the need for human intervention;
2. create and add your own (customised) worksheet functions to the library of worksheet functions;
3. create an interactive program that automates complex and tedious calculations in Excel;
4. interact with other office applications such as Ms Word, Ms Access and MS Powerpoint.