Presented below is a brief introduction to the VBA Editor and a VBA project.
The VBA Editor is where you type, edit and debug your VBA code. A VBA project organizes your code in a workbook file.
The VBA Editor is where you view, type, edit, debug and run your VBA code. VBA code is typed in what are called modules. You can also use the Editor to build userforms which are basically floating screens that display ActiveX controls. The VBA Editor has many windows that can be displayed depending on your coding tasks. You activate the VBA Editor in Excel by pressing the Alt+F11 keys on your keyboard.
When observing VBA code in the Editor, you will see the code is organized in what are called projects. A VBA project in Excel is defined as a collection of VBA modules, userforms and various other programming elements, there is only one VBA project per workbook file. VBA projects are automatically created in Excel when a workbook file is created so you do not have to create one. To save a VBA project and its modules, you save the workbook file that contains them.
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 -VBAProject. It's default position is in the upper left-hand side of the Editor window and looks like a file tree. If you have multiple files open at once, then you will see multiple projects in the Explorer window. To display any project item, just double click on its icon in the Project window. When first starting, it is better to have just one workbook file open so you do not get your projects confused.
Hands-On Excel Training Services
Microsoft Excel Products
EMAGENIT Company Information
US Military Discounts
Copyright © 2002-2020
EMAGENIT All Rights Reserved