How do you call one Sub from another Sub ?
 

Hi,

I have some VBA code attached to a button in sheet3.
I would like to use the exact same code in 6 other sheets.
How do I call this Sub in sheet3 from the other sheets?

Thanks,
Luther



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

How do you call one Sub from another Sub ?
 

One way is to place the code in a macro and place the macro in
a normal module

Usethe macro name in the click event of the button like this

Private Sub CommandButton1_Click()
subname
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"lothario" wrote in message ...
Hi,

I have some VBA code attached to a button in sheet3.
I would like to use the exact same code in 6 other sheets.
How do I call this Sub in sheet3 from the other sheets?

Thanks,
Luther



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

How do you call one Sub from another Sub ?
 

Thanks Ron.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/