This approach was intuitive, but it also had integral weaknesses. For example, if in the user interface you typed R (for “Range”), N (for “Name”), and C (for “Create”), you would enter RNC into the macro to automate the process. In fact, the first spreadsheet macro programs were just shortcuts for the user interface commands. Macros were used with the older versions of office applications and they could only be used for automating instructions. But a Macro language is very much different from a VBA. I have seen many people confusing between VBA and Macro language. Is there any difference between a VBA Program and Macro? Instead Word VBA understand terms like documents, bookmarks etc., things that are more related to Microsoft Word. This means that, Excel VBA, knows about things like workbooks, worksheets, cells and charts, but Word VBA doesn’t knows about such things.

Visual Basic for Applications is bundled with office applications (host application) so that it can be used as medium for accessing and interacting with the host applications object model. And because of this it is sometimes also called as a hosted language. VBA is an extensible programming language that is made up of a core set of commands and extended on a per-application basis to be able to work directly with objects in that application.

VB6 and its associated integrated development environment (IDE). So, all the programming that we are going to do in Excel or in other office application has to be done in VBA.īut technically, VBA is an implementation of Microsoft's event-driven programming language i.e. In most simple terms you can also say that, VBA is the language that Office Applications like Excel, Word, PowerPoint, etc.

Why learning Excel VBA is so important?.

Is there any difference between a VBA Program and Macro?.

Excel vba basics