Excel macro tutorial guru99. Vba is the acronym for visual basic for applications. Excel has features that automatically generated the source code for you. You do not need to be a programmer or a very technical person to enjoy the benefits of macros in excel. Functions are mostly used to carry out repetitive tasks such as formatting data for output performing calculations etc.
For business use you can create complete powerful programs powered by excel and vba. A function is a piece of code that performs a specific task and returns a result. Visual basic for applications vba basics. It is a combination of the microsofts event driven programming language visual basic with microsoft office applications such as microsoft excel.
It is a programming language that excel uses to record your steps as you perform routine tasks. Excel is the most powerful tool to manage and analyze various types of data. The advantage of this approach is you can leverage the powerful features of excel in your own custom programs. Before we can write any code we need to know the basics first.
Vba enables you to automate various activities in excel like generating reports preparing charts graphs doing calculations etc.