Presented below is a brief introduction to a VBA module and their uses.
A VBA module is where you type your computer code. The code you type in a module is run to command a program and perform other tasks.
VBA code is typed and viewed in the VBA Editor in what are called modules. A collection of modules is what is called a VBA project. In the VBA Editor, a VBA module when viewed resembles and behaves like a Word document in both basic organization and typing. When viewed, a VBA module will appear in its own window within the VBA Editor. Think of modules as organizational folders for your code, you add VBA modules as needed to a project to organize and run code.
VBA modules come in three different flavors, when just starting off, you will be typing in a Standard module. The other two are Object and Class modules.
Modules are made up of elemental building blocks called procedures. Procedures are used to organize and run your code in a module. Think of a paragraph in a word document and you are on the right track. You type Excel commands, variables, arrays, loops, logic, functions,... in your VBA module procedures and then run the procedure to control Microsoft Excel and perform various other tasks.
To view a module, just double click on its icon in the Project Explorer window in the VBA Editor. Standard modules are located under the Modules folder. Object modules are located under the Microsoft Excel Objects folder. Class modules are located under the Classes folder. Note that in Microsoft Excel, modules located under the Modules folder or Classes folder can be removed by right mouse clicking on their icons in the Project Explorer window and selecting Remove. They can also be added via the Insert menu.
Hands-On Excel Training Services
Microsoft Excel Products
EMAGENIT Company Information
US Military Discounts
Copyright © 2002-2020
EMAGENIT All Rights Reserved