Microsoft Excel workshops for business, engineering and science Innovative Microsoft Excel software design View our customer list from our over 14 years in business Phone numbers, email address and contact form Learn about EMAGENIT Home page containing upcoming Microsoft Excel classes and other EMAGENIT services Self-study Microsoft Excel manuals for business, engineering and science Microsoft Excel consulting services Microsoft Excel training schedule and prices EMAGENIT newsletter signup - Discounts Contact EMAGENIT about your questions Follow us on linked in and receive discounts up to 25% off our training upcoming Microsoft Excel classes and other EMAGENIT services
Home > Excel Resources > What is a VBA Editor and a VBA Project?

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

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

Read about how you can repeat your Microsoft Excel workshop for free Read about our Microsoft Excel customers Read about how we won an award for our Microsoft Excel software      
 

Need Help Learning Excel VBA?

Let our Microsoft Excel VBA workshops below show you how to command Excel in ways you never thought possible. They are unlike anything taught on the training market today.

Beginning Microsoft Excel VBA - Business

Beginning Microsoft Excel VBA Workshop for Business Professionals - Outline and SignupLearn time saving Excel VBA skills that you can start to use immediately on your tough Excel problems. Drawing on our 15 years' of Excel VBA software design experience, our 2-day "hands-on" workshop shows you how to use VBA to control Excel, perform calculations, process and move data, fill out forms and tables, create charts, build dashboards, control Word and PowerPoint and much more. It provides a complete review of the VBA language. Complete Outline and Signup

Advanced Microsoft Excel VBA - Business

Advanced Microsoft Excel VBA Workshop for Business Professionals - Outline and SignupLearn how to construct advanced Excel VBA solutions that will save time, money and accomplish the seemingly impossible. Drawing on our 15 years' of Excel VBA software design experience, our 3-day "hands-on" workshop shows you how to use VBA to perform advanced analysis and data processing, command ActiveX controls and userforms, construct advanced dashboards, control databases, control Excel's advanced tools like pivot tables and control other programs. Complete Outline and Signup

Beginning Microsoft Excel VBA - Engineering & Science

Beginning Microsoft Excel VBA Workshop for Engineers and Scientists - Outline and SignupOverview: Learn how to use Excel VBA to construct engineering / science tools that reduce your tasks from days to minutes. Drawing on our award winning NASA software design experience, our 2-day "hands-on" workshop shows from an engineering & science perspective how to use VBA to control specific Excel features, process technical data, fill out forms and tables, perform sophisticated calculations, create technical charts, create custom worksheet functions for modeling, control Word and PowerPoint and much more. Taught by an engineer. Complete Outline and Signup

Advanced Microsoft Excel VBA  - Engineering & Science

Advanced Microsoft Excel VBA Workshop for Engineers and Scientists - Outline and SignupLearn to how use Excel VBA to build advanced engineering / science tools that perform complex technical tasks. Drawing on our award winning NASA software design experience, our 3-day "hands-on" workshop shows you from an engineering & science perspective how to use VBA to create advanced data analysis tools, advanced technical models, advanced database tools, dashboards using ActiveX controls and userforms and control other programs like Word and PowerPoint.  Taught by an engineer. Complete Outline and Signup

 

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.

    • Projects are 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.

Visual Basic Editor Displaying Module3

 

  • 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.

 

<<What is VBA?       What is a VBA Module and How is It Used?>>

 

 

 

 

 

Site Map

Copyright 2002-2014 EMAGENIT All Rights Reserved