top of page
  • Writer's picturePadmapriya V

What is VBA?

Visual Basic for Applications (VBA) is an implementation of Microsoft's Event-Driven Programming language Visual Basic 6.0 built into most desktop Microsoft Office applications. Although based on pre-.NET Visual Basic, which is no longer supported or updated by Microsoft, the VBA implementation in Office continues to be updated to support new Office features. VBA is used for professional and end-user development due to its perceived ease-of-use, Office's vast installed userbase, and extensive legacy in business.

Visual Basic for Applications enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs).

As its name suggests, VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library. VBA can, however, control one application from another using OLE Automation.

7 views0 comments

Recent Posts

See All

Beginning of Excel

On September 30, 1985, Microsoft released Excel into the world. First built for Macintosh, Microsoft added a Windows version in November of 1987, and the world of finance and accounting has never been


bottom of page