Visual Basic

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hello,

How do you execute an outside sub procedure from an
existing sub procedure? i.e. If value = 5 Then run
sub "1", ElseIf value = 4 Then run sub "2".

Thanks for your help,
Todd
 
Todd,

If value = 5 Then
Call sub1 ....

I have seen
Run sub1

My favorite is
Module1.Macro1
this identifies the module and the macro for easier trouble shooting.

It gets a little trickier if the sub is in another workbook, but it can be
done.
 
Steve,

Thank you very much. It worked!

Todd

-----Original Message-----
Todd,

If value = 5 Then
Call sub1 ....

I have seen
Run sub1

My favorite is
Module1.Macro1
this identifies the module and the macro for easier trouble shooting.

It gets a little trickier if the sub is in another workbook, but it can be
done.

--
sb



.
Click to expand...
 
Back
Top