Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a Module
How do I call a module from another module?
Thanks, mb |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
to call procedure in a worksheet in a module | Excel Discussion (Misc queries) | |||
Call to Re-Named Module [to match Sub() name] fails ? | Excel Programming | |||
Call other sub in the same module | Excel Programming | |||
how to call Access's function in different module in Excel VBA | Excel Programming | |||
how to call Access function&module in Excel VBA?? | Excel Programming |