Versions Compared

Old Version 24

changes.mady.by.user Unknown User (jonakaa)

Saved on

compared with

New Version 25

changes.mady.by.user Unknown User (jonakaa)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

About Visual Basic for Applications

Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6. 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 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.

BibTeX Referencing
reference@misc{wikipedia_2019, title={Visual Basic for Applications}, url={https://en.wikipedia.org/wiki/Visual_Basic_for_Applications}, journal={Wikipedia}, publisher={Wikimedia Foundation}, author={Wikipedia}, year={2019}, month={Jun}}

Info

The abbreviation VBA will mainly be used when referring to Visual Basics for Applications.


Bilderesultat for visual basic for applications logo

Panel
borderColor#dfe1e5
bgColor#eff9ff
borderWidth2
titlePage content

Table of Contents



VBA is already included in Excel, so all we have to do is to enable its shortcut.

  • Click on "File" and open the "Options" section in Excel
    • Go to the "Customize Ribbon" section and mark off for "Developer". Click "OK".
    Image Removed
    The VBA editor is now available under the "Developer" tab.
    Image Removed

    How to enable VBA in the different Office programs is described in each program child page.

    Panel

    How to download and install Visual Basic for Applications

    Expand
    titleExcel: Enable VBA editor shortcut



  • Check out our guide Beginner tutorials on VBA, Excel.
    • I found the Youtube tutorials by Tiger Spreadsheet Solutions to be both informative and understandable when first learning VBA
    • .

    Some useful information when coding can also be found at Tips and tricks for coding.

    Panel

    Getting started with Visual Basic for Applications

    There are a lot of great VBA tutorials online, so if you don't find what you're looking for in this wiki, check them out.

    Expand
    titleExcel



    Useful tutorials

    Our tutorials:

    Our exercises:

    External tutorials:

  • VBA references by Microsoft
    • VBA tutorials by Tutorialspoint
    Panel
    Expand
    titleExcel





    BibTeX Display Table