Call a Module
 

How do I call a module from another module?

Thanks,
mb

Call a Module
 

Prefacing a call with the module name is optional when calling a sub or
function in another module but it is ususally a good idea. It also makes the
call easier as intellisense in VB will display all of the public variables,
subs or functions for you when you type the period.

Call module1.myFunction(myArgument)
--
HTH...

Jim Thomlinson


"mb" wrote:

How do I call a module from another module?

Thanks,
mb

Call a Module
 

And if the macro is in another workbook then:
Application.Run "WorkbookName!MacroName"

Regards
Rowan

mb wrote:
How do I call a module from another module?

Thanks,
mb