Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
i´d like to know how to call a sub inside other sub. If i have a sub that a user can trigger by clicking a button, i´d like to call another sub in the middle of the code. In a pseudo-code example that should look like: sub Proc1() 'do something call Proc2 'do something else end sub |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try your pseudo code. I bet it'll work.
bbussoloti wrote: Hi i´d like to know how to call a sub inside other sub. If i have a sub that a user can trigger by clicking a button, i´d like to call another sub in the middle of the code. In a pseudo-code example that should look like: sub Proc1() 'do something call Proc2 'do something else end sub -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That should work just fine.
Dale -- Don''t forget to rate the post if it was helpful! Email address is not valid. Please reply to newsgroup only. "bbussoloti" wrote: Hi i´d like to know how to call a sub inside other sub. If i have a sub that a user can trigger by clicking a button, i´d like to call another sub in the middle of the code. In a pseudo-code example that should look like: sub Proc1() 'do something call Proc2 'do something else end sub |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
sub Proc1() 'do something Proc2 argument1, argument2, ... 'or use the Call keyword Call Proc2(argument1, argument2, ...) end sub -- Regards, Sébastien <http://www.ondemandanalysis.com "bbussoloti" wrote: Hi i´d like to know how to call a sub inside other sub. If i have a sub that a user can trigger by clicking a button, i´d like to call another sub in the middle of the code. In a pseudo-code example that should look like: sub Proc1() 'do something call Proc2 'do something else end sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
bar inside larger bar | Charts and Charting in Excel | |||
Possible to call a procedure inside a function? | Excel Programming | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
using variable inside activeCell reference call | Excel Programming | |||
Call a proc inside itself (HELP) | Excel Programming |