Thread: Stringing Subs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randal W. Hozeski Randal W. Hozeski is offline
external usenet poster
 
Posts: 33
Default Stringing Subs

I have a number of Subs:

Private Sub CommandButton1_Click()
Private Sub CommandButton2_Click()
Private Sub CommandButton3_Click()
etc.

They are pretty large.
Instead of coping the code into other Sub is
there a way to run all three at the same time?

???
Sub NewSub
Run Private Sub CommandButton1_Click()
Run Private Sub CommandButton2_Click()
Run Private Sub CommandButton3_Click()
End Sub
Does not work, any sugestions?

-Randy-