Is it possible to call a function from one Module to another I have the following code Sub MAIN Call IDLE End Sub MAIN is located in Module1 IDLE is located in Module2 and defined as Sub IDLE

[vba] Call a Subroutine from a different Module in VBA

Is it possible to call a function from one Module to another?

I have the following code:

Sub MAIN()
    Call IDLE
End Sub

MAIN is located in Module1
IDLE is located in Module2 and defined as: Sub IDLE()

This question is related to vba module call

The answer is

Prefix the call with Module2 (ex. Module2.IDLE). I'm assuming since you asked this that you have IDLE defined multiple times in the project, otherwise this shouldn't be necessary.

Source: Stackoverflow.com

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?

Examples related to module

• How to fix: fatal error: openssl/opensslv.h: No such file or directory in RedHat 7 • How to import functions from different js file in a Vue+webpack+vue-loader project • Typescript ReferenceError: exports is not defined • ImportError: No module named tensorflow • ModuleNotFoundError: What does it mean __main__ is not a package? • ES6 modules in the browser: Uncaught SyntaxError: Unexpected token import • module.exports vs. export default in Node.js and ES6 • What's the difference between an Angular component and module • Export multiple classes in ES6 modules • Python - Module Not Found

Examples related to call

• ReactJS - Call One Component Method From Another Component • Call a Class From another class • What does it mean to "call" a function in Python? • How to make method call another one in classes? • How to call a mysql stored procedure, with arguments, from command line? • Submit form on pressing Enter with AngularJS • Running bash script from within python • javascript: get a function's variable's value within another function • Passing variables, creating instances, self, The mechanics and usage of classes: need explanation • Android Call an method from another class

[vba] Call a Subroutine from a different Module in VBA

The answer is

Examples related to vba

Examples related to module

Examples related to call

Tags