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 Module and How is a VBA Module Used?

What is a VBA Module and How is a VBA Module Used?

What is a VBA Module and How is a VBA Module Used?

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 a VBA Module?

  • VBA code is stored and typed in the VBA Editor in what are called modules.

    • As stated on the VBA Editor page, a collection of modules is what is called a VBA project.

    • Every major Microsoft Office product has a VBA Editor and can use VBA code to control itself.

    • The VBA Editor can be activated by pressing the Alt+F11 keys in a Microsoft Office product.

  • To view a module, just double click on its icon in the Project Explorer window in the VBA Editor.

    • For example, if you wanted to view the Module3 module then just double click on it with your mouse. This is illustrated in the picture below.

    • 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 VBA module basically works like a Word document and follows the same basic typing rules.

Visual Basic Editor Displaying Module3

 

  • You type code in a module then run it to control the program you want to control.

    • For a program to be controlled with VBA it just has to be what is called VBA compatible. It does not have to be a Microsoft product.

      • For example the code pictured above is designed to command Microsoft Excel.

    • You can be in Microsoft Excel and control Word or Access or vice versa. Remember, it does not matter where the VBA module resides (i.e. what program), it is the code that controls whatever you are trying to command not its location.

  • The code you type in a module comes from what can be referred to as a library.

    • Programs expose their libraries to VBA allowing VBA to control them.

    • Want to command a program, then reference its library in VBA then learn its commands so you can type them in your modules.

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

    • When removing a module, you have the choice to save it.

 

<<What is the VBA Editor?          What is a VBA Procedure?>>

 

 

 

 

Site Map

Copyright 2002-2014 EMAGENIT All Rights Reserved