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, 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.
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, ActiveX/COM DLLs, and later versions add support for class modules.
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, CorelDraw, LibreOffice, Reflection, SolidWorks, WordPerfect, and UNICOM System Architect (which supports VBA 7.1).

You do not have permission to view the full content of this post. Log in or register now.
  1. V

    Tutorial Simply Supported Beam with Uniformly Distributed Load | Load+Shear+Moment+Deflection Diagram using EXCEL.

    Simply Supported Beam with Uniformly Distributed Load | Load+Shear+Moment+Deflection Diagram using EXCEL. Microsoft Excel can be a powerful tool for engineering and analysis tasks, including the creation of shear force, bending moment, and deflection diagrams. Here's a step-by-step guide on how...
  2. D

    Help Excel VBA?

    Hi mga boss! Baka may nakaka alam anong site or tutorial pwede gumawa or matuto ng VBA Excel? 🤔 Para magamit as ninjutsu. 🥷 For example yung kusang gagalaw yung mouse cursor after 10 seconds. Balak ko kasi gumawa nung kaya mag switch ng application from excel to notepad and vice versa. Sorry...
  3. R


    Hello po good day ka PHC. Ask ko lang po if pano ko po mailalagay yung dollar and euro pag nag dropdown ako sa isang cell. kumbaga ang magiging value po nya pag nagclick ng Dollar ay "SIX HUNDRED FORTY FIVE AND 00/100 DOLLAR ONLY" Refer po sa video. Maraming maraming salamat po.
  4. S

    Help VBA MACRO - Missing Outlook Signature

    Hello Sino po marunong mag VBA Macro dito.. hindi kasi nag aappear ung Outlook Signature ko kapag pineperform ko ung macro ko.. bakit po kaya.. ito po ung codes ko. Sub Mail_Outlook_With_Signature_Html_1() 'Updated by Extendoffice 2018/11/22 Dim xRgDate As Range Dim xRgSend As Range...
  5. 1

    Help Microsoft excel, Macro

    Mga lods, baka alam nyo to. Ang MS excel kasi ngaun ay parang nka auto disable ang Macro. Naayos ko naman to sa trust settings at trusted folder. Ngaun during run ng Macro, ok naman normal, maliban sa isa. Hindi na sya nag sesend ng email sa outlook after ng transaction. Parang un ung hnd...
  6. B

    MS Excel Payslip Email Sender and Printer using VBA

    Hello po, Gumagawa po kasi ako nang mga Excel Templates with VBA Programming. Baka po Meron interested sa inyo: Features: This Project Sample is Payslip Sender, it can also be transformed into Sales invoice notification, Purchase Order notification, or any email notification for companies...
  7. D

    Help Recommended Books for Ms Excel VBA, MACRO.

    Any book recommendations po for VBA macro? For beginner lang po sana. Need lang po for work. Thank you 🙂
  8. E

    Course Percipio Course VBA- Getting Started with VBA in Excel

    Sa mga naghahanap ng excel VBA tutorial. See link nalang to download the videos. https://www.mediafire.com/file/chb4ejs547p4uwb/Excel_VBA.zip/file Hope this will be helpful.
  9. P

    I just made an application using excel??

    Heyy guyss flex ko lang yung vacation practice ko with Excel. Kung ano ano na nagagawa ko sa computer ko HAHAHA. Ano masasabi niyo? Asking for my skills? Check it here --> https://raldincasidar.ga/ Web Dev po talaga ako and na discover ko lang na pwede pala gumawa ng ganyan sa excel😂
  10. A

    Visual Basic Help Excel VBA

    Pa help naman po kung sino magaling sa VBA programming dito. 1. Pag run po ng macro, need ko po ma auto delete yung mga unnecessary rows. 2. need ko po na auto refresh nya yung source path bago nya icopy yung data to a new workbook. Yung Shelton test folder po ang source folder (paki extract...
  11. A

    Tutorial VBA for Dummies

    VBA programming applicable for MAcro in microsoft excel. https://dropmb.com/download/2aa4f25ae67e24a85b004bd52a44de61.html
  12. K

    Closed Vba clear cell contents with value

    Guys pa tulong po about dito gusto ko sana i delete yung cell na may "B0" sa column H Ano kaya code para dito yung parang ganito kaso ayaw gumana Range(H1, H6000).Value = ("*B0*").clearcontent wala akong masyadong alam sa macro. Salamat
  13. C

    Compilation of programming pdf's

    Hello ! Para to sa mga gusto pa palawakin ang knowledge nila sa programming. Malaki ang naitutulong nito sa akin, and I'm sure makakatulong din ito sa iniyo :) Titles: .NET Framework Notes Algorithms Notes Android® Notes Angular 2 Notes AngularJS Notes Bash Notes C Notes C++ Notes C#...
  14. E

    Closed If else if statement error

    Hello guys. I'm trying to work an OLD PLanguage which is the VBA on Excel not familiar dahil medyo iba ang mga Functions Compare sa PL na Visual Basic. Let's Start! Trying to make a Log in Form Validating on the Current Sheet. Error ko yung Condition na: IF ELSE IF Statement Cmd_Submit_Click...
  15. E

    Closed Vba codes in excel macro

    guys pa help naman ako. Im coding a TAM tools( Time and Motions Tools) in Excel macro (VBA Codes). Gusto ko ihiwalay yung date at time sa ibang cell kung baga separated sila kapag pinindot ko na yung Buttons this is my codes. Sub Start_time() Range("F" & ActiveCell.Row).Select...
  16. S

    Gameboy Opening gba file in Virtual Boy Advance

    Steps on how to configure Visual Boy Advance and to open gba files. First - Download muna kayo ng gba roms. Pili lang kayo sa mga sites na to. Pwede din kayo sa ibang sites basta siguraduhin nyo lang na English or may (U) or (UE) or (US) ang version nya at di (J) (kung marunong at...
  17. S

    Gameboy Want a VIRTUAL Game Boy?

    Eto mga ka PHC share ko to hehehe pag wala akong ma gawa, walang net o free time, eto nilalaro ko. Sa mga gameboy addicts jan i'm sure some of you alam na to. Pero ishashare ko parin para madagdagan naman ng thread ang category na to :D So let me introduce to you Visual Boy Advance (a.k.a VBA)...