View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gareth[_6_] Gareth[_6_] is offline
external usenet poster
 
Posts: 158
Default Tie 2 or More Modules Together (vba)

If you have

Module1
Sub1
Sub2

Module2
Sub3
Sub4

you should be able to call each sub(or function) from within the other
modules *unless* you prefaced the name with Private or the procedure
you're trying to call is in a Userform/Sheet/ThisWorkbook module.

e.g.

Sub IDoWork()
'can be called from within any other procedure
End Sub

Private Sub IDontWork()
'can only be called from a procedure from within the same module
End Sub




zero635 wrote:
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