What is the VBA Editor and What is a VBA Project

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

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

  • VBA code is typed, edited, viewed, debugged and run in the VBA Editor.

  • The VBA Editor behaves just like Microsoft Word when typing in what are called modules (pictured to the right).

  • A VBA module resembles a Word document in both organization and typing

  • The VBA Editor organizes and displays VBA modules in what are called a VBA projects

  • A VBA project is defined as a collection of VBA modules and other programming elements

  • When a new workbook file is created in Microsoft Excel, a new VBA project is automatically created and associated with that workbook

  • A workbook can contain only 1 VBA project

  • You add VBA modules, code and other elements to a VBA project when you need them

Back to the Resource Center

 
How We Can Help With Your Training?

Self-Study Training

Public Workshops

On-Site Training

Webcast Training

Our self-study manuals contain extensive Microsoft Excel and Microsoft Excel VBA knowledge based on our consulting and software design experiences. They contain not only how-to information, but also practical application discussions. In our manuals, you get everything we use when we develop for clients. EMAGENIT has developed software for such company's as Northrop Grumman, NASA JPL, Caterpillar and the US Navy. View Manuals and Prices...  

In our Microsoft Excel and Microsoft Excel VBA public workshops, you will learn "hands-on" from an experienced Excel developer. Our Microsoft Excel developers have real world experience designing worksheets and software for companies and organizations like Verizon, Caterpillar, The US Navy and NASA JPL. We limit our public workshops to 10 people or less so we can concentrate on your problems. Our workshops are never "canned" and we adjust the curriculum of each class based on the particular needs of the attendees. Best of all, you can repeat the workshop as many times as you want free. Schedule and Workshop Information...

Our onsite workshops feature “hands-on” training custom designed to your company’s needs. EMAGENIT provides this customization of Excel or Excel VBA curriculum at no extra cost. EMAGENIT has an extensive training and development background that is integrated into every class. With over 14 years of experience and knowledge, we can help solve your Excel problems. Our onsite training is also less expensive than your staff taking our public workshops. More Information... Using our live webcast technology, EMAGENIT can train you or your company from anyplace in the world. We can simulcast our public workshops or train your company exclusively through our live webcast. EMAGENIT's webcast is fast becoming a valuable tool for many company's as they try to keep costs down and productivity up. Our webcast gives you a live, voice interactive and "hands-on" workshop tailored to your needs.  Schedule and Workshop Information...