Content deleted Content added
mNo edit summary Tag: Reverted |
mNo edit summary |
||
Line 19:
| wikibooks =
}}
'''Visual Basic for Applications''' ('''VBA''') 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 (except under Microsoft's "It just works" support), 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.
| |||