Thread: How to run sub?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How to run sub?

From another control in the same Worksheet or userform?

Just execute it like you would any macro

Private Sub CommandButton2_Click()
CommandButton1_Click
msgbox "Executed the click event for CommandButton1"
End Sub

--
Regards,
Tom Ogilvy

"Boban" wrote in
message ...

How to run sub from sub?

I want to run for example CommandButton1_Click() from other control
sub.


--
Boban
------------------------------------------------------------------------
Boban's Profile:

http://www.excelforum.com/member.php...o&userid=28560
View this thread: http://www.excelforum.com/showthread...hreadid=482541