What is a VBA Project and What is the VBA Editor?

What is a VBA Project and What is the VBA Editor?

Microsoft Excel VBA Tutorial

The VBA Editor is where you type, edit and debug your VBA code for your workbook project.

What is the VBA Editor and What is a VBA Project?

  • VBA code is typed, edited, viewed, debugged and run in the VBA Editor.
    • Each major Microsoft Office product has a VBA Editor
    • The VBA Editor can be activated in all the major Microsoft Office programs by pressing the Alt+F11 keys on your keyboard
  • VBA code is typed in a module within a project in the VBA Editor
    • A VBA project is defined as a collection of VBA modules and other programming elements
    • A VBA project is part of a file. If you are in Microsoft Excel then it will be part of a workbook file. If you are in Word, then it will be part of a Word document.
    • A Project is automatically created when you create a file in a Microsoft Office product. For example, when a new workbook file is created in Microsoft Excel, a new VBA project is automatically created and associated with that workbook.
  • Projects are viewed in the Project Explorer window in the VBA Editor
    • The Project Explorer window is presented in the picture below and is labeled Project - ..... It is in the upper left hand side of the window and looks like file tree.
    • If you have multiple files open at once then you will see multiple projects in the Explorer window.
      • For example, in the VBA Editor for Excel pictured below, there are two projects visible in the Explorer window since two workbook files are open at once in Excel.
  • When first starting, it is better to have just one file open so you do not get your projects confused.
VBA Editor, VBA Module, VBA Procedure

VBA Editor and VBA project (Click to Enlarge)

  • As previously stated, VBA code is stored within a module in a project
    • To view a module, just double click on its icon in the Project Explorer window
      • For example, if you wanted to view the VBA module called Module3 then just double click on it with your mouse
    • A VBA module will resemble a Word document in both organization and typing
    • A VBA module will appear in its own window within the VBA Editor when you double click on it to view it
  • A workbook can contain only 1 VBA project
  • You add VBA modules, code and other elements to a VBA project when you need them

We Can Teach These Skills to You - Our Microsoft Excel VBA Training

Beginning Microsoft Excel VBA Training for Business

Beginning Excel VBA Training for Business Professionals

Our 2-day "hands-on" beginning Microsoft Excel VBA training shows you the essential Excel VBA programming skills that you need to immediately develop useful powerful data processing and analytical tools that your business needs now. View Outline

Advanced Microsoft Excel VBA Training for Business

Advanced Excel VBA Training for Business Professionals

Our 3-day "hands-on" advanced Microsoft Excel VBA training shows you how to build advanced data processing tools, analysis tools and dashboard displays using Microsoft Excel VBA that will solve the most difficult business tasks. View Outline

Beginning Microsoft Excel VBA Training for Engineers and Scientists

Beginning Excel VBA Training for Engineers and Scientists

Our 2-day "hands-on" beginning Microsoft Excel VBA training shows you how to use Excel VBA to control key Excel engineering and science features, format and process technical data, perform sophisticated calculations, create technical charts, create custom worksheet functions, manage large models and data, create report tools and much more. Taught by an engineer. View Outline

Advanced Microsoft Excel VBA Training for Engineers and Scientists

Advanced Excel VBA Training for Engineers and Scientists

Our 3-day "hands-on" advanced Microsoft Excel VBA training shows you how to use Excel VBA to build advanced engineering and science tools that that solve your most difficult data and analysis tasks and help you visualize your data sophisticated interfaces. Taught by an engineer. View Outline



Site Map

Copyright © 2002-2015

EMAGENIT All Rights Reserved