Thread: Subs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Subs

As long as all of the subs are in standard modules...

Private Sub RUN_Click()
ThisWorkbook.Worksheets.Add
Questions
Me.Hide
Unload Test
OtherSub2
OtherSub3

OtherSub4
OtherSub5

OtherSub6
OtherSub7

OtherSub8
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Donna C"
wrote in message
I had one rather large sub that worked great, I broke down into 8 seperate
subs to simplify code changes later on.I have a user form with a run button.
Originally it ran the one sub and worked great.Now with it split into many
how do I go from one sub straight into the next one until all are run??? This
is what the code looks like with just one of the subs listed.
Thanks in advance,
Donna C.

Private Sub RUN_Click()
ThisWorkbook.Worksheets.Add
Questions
Me.Hide
Unload Test
End Sub