Visual Basic for Applications

Also known as Microsoft Proprietary Alexandre Concon

Microsoft Proprietary Alexandre Concon

Key facts

Paradigm: Multi-paradigm
Developer: Microsoft
First appeared: 1993 ; 33 years ago ( 1993 )
Stable release: 12 712 ( Office 2021 )
Typing discipline: Static/Dynamic Hybrid , Strong/Weak Hybrid
Os: Microsoft Windows , macOS
License: Commercial proprietary software
Website: learn .microsoft .com /en-us /office /vba /library-reference /concepts /getting-started-with-vba-in-office

via Wikipedia infobox

Wikidata facts

Official website: learn.microsoft.com/de-de/office/vba

Sources (4)

Article

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 (except under Microsoft's "It Just Works" support which is for the full lifetime of supported Windows versions, including Windows 10 and Windows 11), 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). It supersedes and expands on the abilities of earlier application-specific macro programming languages such as Word's WordBASIC. It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.