ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   call sub inside other sub (https://www.excelbanter.com/excel-programming/401937-call-sub-inside-other-sub.html)

bbussoloti

call sub inside other sub
 
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

call sub inside other sub
 
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

Dale Fye

call sub inside other sub
 
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


sebastienm

call sub inside other sub
 
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



All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com