Learn BI Reporting from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

What is a VBA Module?

ITech Analytic Solutions
30/12/2016 0 0
  • 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
  • VBA modules come in three different types, when just starting, you will be typing in a standard module
  • 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

VBA Editor, VBA Module, VBA Procedure

VBA Module (Click to Enlarge)

  • 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
0 Dislike
Follow 0

Please Enter a comment


Other Lessons for You

Macros/VBA Function - Format
Hi VBA/Macro Learners, Today we will see how to use FORMAT Function in VBA to get modify the format of Numbers,Dates,Times & String. Syntax: FORMAT(expression,format,,) 'Ex1: Modify the Format...

HDFS Commands - Data Engineering
HDFS commands : HDFS commands will interact with namenode to show results some commands like cat ,tail will interact with datanode to show results HDFS help commands: hadoop fs -help ls list commands...

How to create UDF (User Defined Function) in Hive
1. User Defined Function (UDF) in Hive using Java. 2. Download hive-0.4.1.jar and add it to lib-> Buil Path -> Add jar to libraries 3. Q:Find the Cube of number passed: import org.apache.hadoop.hive.ql.exec.UDF; public...

Sachin Patil

0 0

Excel Database Functions List
Excel Database Functions List Database Functions DAVERAGE Calculates the average of values in a field of a list or database, that satisfy specified conditions DCOUNT Returns...

Uma Sahu

0 0

What is M.S.Project ?
MICROSOFT PROJECT contains project work and project groups, schedules and finances.Microsoft Project permits its users to line realistic goals for project groups and customers by making schedules, distributing...

Looking for BI Reporting Training?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for BI Reporting Classes?

The best tutors for BI Reporting Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn BI Reporting with the Best Tutors

The best Tutors for BI Reporting Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more