Content deleted Content added
m Bringing or calling developer tab for active x or vba form control on a excel sheet Tag: Reverted |
|||
Line 23:
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.
As its name suggests, VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library. However, VBA code normally can only run within a host application, rather than as a [[standalone program]]. VBA can, however, control one application from another using [[OLE Automation]]. For example, VBA can automatically create a [[Microsoft Word]] report from [[Microsoft Excel]] data that Excel collects automatically from polled sensors. VBA can use, but not create, [[Component Object Model|ActiveX/COM]] DLLs, and later versions add support for class modules.An user or a developer has to bring developer tab in excel page from file menu -->Options-->Customize ribbon and then click on developer tab and then click on interest tab. Active x or form controls such as text box, label, combo box, radio button, tick, image box can be brought here.
VBA is built into most [[Microsoft Office]] applications, including Office for Mac OS X (except version 2008), and other Microsoft applications, including [[Microsoft MapPoint]] and [[Microsoft Visio]]. VBA is also implemented, at least partially, in applications published by companies other than Microsoft, including [[ArcGIS]], [[AutoCAD]], [[Collabora Online]], [[CorelDraw]], [[WPS Office|Kingsoft Office]], [[LibreOffice]],<ref>{{cite web | title=Support for VBA Macros | publisher=The Document Foundation - LibreOffice| url=https://help.libreoffice.org/latest/lo/text/sbasic/shared/vbasupport.html |access-date=3 January 2023}}</ref> [https://www.microfocus.com/products/reflection/desktop/ Reflection],<ref>{{Cite web|url=http://docs.attachmate.com/reflection/16-1/vba-prog-guide|title=Reflection Desktop VBA Guide|website=docs.attachmate.com|access-date=2017-07-01}}</ref> [[SolidWorks]],<ref>{{Cite web|url=http://help.solidworks.com/2016/English/SolidWorks/sldworks/c_vba.htm|title=2016 SolidWorks Help – VBA|website=help.solidworks.com|access-date=2016-07-25}}</ref> [[WordPerfect]], and UNICOM [[System Architect]] (which supports VBA 7.1).
| |||