View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default Tie 2 or More Modules Together (vba)

From a macro in a standard module you should be able to call another macro
in a standard module.

Run "Macro1_name"

it gets a little trickier if the macro to run is in a sheet module or in
another workbook.

--
steveB

Remove "AYN" from email to respond
"zero635" wrote in
message ...

Can anyone tell me if there is a formula or coding that would tell one
module to reference another? I am trying to get it where when it runs
through my code and reaches a true statement then it would then go onto
the next module and do the same. I am working with several sections in
an excel worksheet so I am trying to keep my coding separate and clean.
If anyone could help I would appreciate it.

Thank You,
Chris


--
zero635
------------------------------------------------------------------------
zero635's Profile:
http://www.excelforum.com/member.php...o&userid=24802
View this thread: http://www.excelforum.com/showthread...hreadid=387568