Call a Subroutine from a different Module in VBA

vba module call
Nimrod picture Nimrod · May 10, 2010 · Viewed 228.1k times · Source

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()

Answer

dcp picture dcp · May 10, 2010

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.

Related questions

Passing variable from Form to Module in VBA

I have the following button on a Form: Private Sub CommandButton1_Click() Dim pass As String pass = UserForm1.TextBox1 Unload UserForm1 End Sub I then have a Module called Module1: Public Sub Login() ... UserForm1.Show driver.findElementByName("PASSWORD").SendKeys pass ... …

Read More
Calling UserForm_Initialize() in a Module

How can I call UserForm_Initialize() in a Module instead of the UserForm code object?

Read More
How to declare Global Variables in Excel VBA to be visible across the Workbook

I have a question about global scope and have abstracted the problem into a simple example: In an Excel Workbook: In Sheet1 I have two(2) buttons. The first is labeled SetMe and is linked to a subroutine in Sheet1's …

Read More