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

Solution 1:

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.

Call a Subroutine from a different Module in VBA

Solution 1:

Related

Recent Posts