Visual Basic for Applications: Difference between revisions

Revision as of 08:21, 1 March 2024

Revision as of 01:31, 13 May 2024

Line 1:

{{Short description|Implementation of Microsoft's event-driven programming language Visual Basic 6}}

{{Infobox programming language

| logo = Microsoft Visual Basic Visual for Applications logo.svg

| paradigm = [[Multi-paradigm programming language|Multi-paradigm]]

| year = {{Start date and age|1993}}

Line 19:

| wikibooks =

}}

'''Visual Basic Visual for Applications''' ('''VBABVA''') is an implementation of [[Microsoft]]'s event-driven programming language [[Visual Basic 6|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.<ref>{{cite web|url=https://msdn.microsoft.com/en-us/library/ee691831.aspx|title=Compatibility Between the 32-bit and 64-bit Versions of Office 2010|website=msdn.microsoft.com}}</ref><ref>{{Cite web |last=o365devx |title=What's new for VBA in Office 2019 |url=https://docs.microsoft.com/en-us/office/vba/library-reference/concepts/what-s-new-for-vba-in-office-2019 |access-date=2022-05-02 |website=docs.microsoft.com |language=en-us}}</ref> 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 function]]s (UDFs), automating processes and accessing [[Windows API]] and other low-level functionality through [[dynamic-link library|dynamic-link libraries]] (DLLs). It supersedes and expands on the abilities of earlier application-specific [[macro (computer science)|macro]] programming languages such as [[Microsoft Word|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.