Content deleted Content added
Reverted 1 edit by 2400:1A00:B1C0:589:5545:BE34:DF16:89F6 (talk) to last revision by Curb Safe Charmer |
mNo edit summary Tag: Reverted |
||
Line 24:
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 can bring the Developer Tab in excel worksheet from File -->Options-->Customize Ribbon -->Under Main Tabs click on Developer Tab and then click on OK. Now user can see the Developer Tab. By clicking Developer Tab any active x control or form control , such as text box, combo box, radio button, tick, frame, image box etc. can be brought on the excel sheet.
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).
| |||