Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wouldn't know what to call it! | Excel Worksheet Functions | |||
I'm not sure what you'd call it, but is it possible to do this? | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Don't know what to call what I need? | Excel Worksheet Functions | |||
call sub | Excel Programming |