View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default Running Multiple Modules With 1 Command

Gary,

Modules do not run. Procedures and Functions within Modules run.

If a procedure within a module has the same name as a procedure in another
module, then you can qualify procedures with the module name. eg.

Sub Test()
Module1.RunMeForEffect()
Module2.RunMeForEffect()
End Sub

Within Module 1:
Sub RunMeForEffect()
MsgBox "Message Box 1"
End Sub

Within Module 2:
Sub RunMeForEffect()
MsgBox "Message Box 2"
End Sub



--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Gary" wrote in message
...
Would anybody have any idea how to use one procedure to run multiple

number of modules at one time. I have ~13 different modules and need to
call the modules in various combinations. Many thanks!