Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
mb mb is offline
external usenet poster
 
Posts: 10
Default Call a Module

How do I call a module from another module?

Thanks,
mb


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,119
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 414
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
to call procedure in a worksheet in a module CAPTGNVR Excel Discussion (Misc queries) 4 January 30th 07 09:39 PM
Call to Re-Named Module [to match Sub() name] fails ? CRayF Excel Programming 4 September 26th 05 05:45 AM
Call other sub in the same module yangyh[_4_] Excel Programming 1 September 11th 05 09:24 AM
how to call Access's function in different module in Excel VBA miao jie Excel Programming 0 July 25th 04 04:03 AM
how to call Access function&module in Excel VBA?? miao jie Excel Programming 1 July 24th 04 04:49 PM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"