Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 169
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 694
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
bar inside larger bar Gklass Charts and Charting in Excel 2 February 14th 08 07:12 PM
Possible to call a procedure inside a function? suomi Excel Programming 2 January 3rd 07 06:35 PM
Call Center Management: How to calculate 'cost per call' Denniso6 Excel Discussion (Misc queries) 2 June 25th 06 05:01 PM
using variable inside activeCell reference call dabith[_7_] Excel Programming 2 June 19th 04 08:02 PM
Call a proc inside itself (HELP) David Excel Programming 2 February 4th 04 08:28 PM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"