| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Visual Basic
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 "Todd" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Visual Basic
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 "Todd" wrote in message ... 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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Visual Basic
Todd,
Glad to be of help! Keep on Exceling... -- sb "Todd" wrote in message ... 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 "Todd" wrote in message ... 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
| In visual basic | Excel Worksheet Functions | |||
| visual basic | Excel Discussion (Misc queries) | |||
| changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
| Visual Basic | Excel Programming | |||
![Todd[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
