VBA or Visual Basic for applications is the programming language used in Microsoft Office applications.

Excel VBA is a powerful language that will enable you to replicate almost every operation you can perform with the mouse or the keyboard in Excel, and many more.

you cannot. There are lots of reasons why Excel VBA programming can be useful.

It can save hours by automating repetitive processes.

It can produce functionality not possible with Excel alone.

It can create visually attractive user interfaces and it can create interactive financial models.

It will also enable us to perform complex analysis much more quickly than is possible in the front end of Excel alone.

However, Excel VBA is not as intuitive as the front end of Excel that we may be more familiar with jumping in to write Excel VBA code before first. Understanding the programming language can lead to hours of wasted time trying to decipher our code.

It can lead to lots of time being spent developing overly complex models and ultimately huge frustration.