Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
one button for many (macro)
I've got a sheet in a workbook where I put 6 buttons; each one is assigned
to a macro and for my purpouse (and to control that code I write do the right thins) I press them sequentially from 1 to 6 . Now, how can I define another TIA button that "press" buotton from 1 to 6 sequentially...? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
one button for many (macro)
Hi
You can call several macros from one, that is pretty essential in programming: Sub Macrocollection() Call Macro1 Call Macro2 Call Macro3 End Sub Sub Macro1() MsgBox "1" End Sub Sub Macro2() MsgBox "2" End Sub Sub Macro3() MsgBox "3" End Sub HTH. Best wishes Harald "uriel78" skrev i melding ... I've got a sheet in a workbook where I put 6 buttons; each one is assigned to a macro and for my purpouse (and to control that code I write do the right thins) I press them sequentially from 1 to 6 . Now, how can I define another TIA button that "press" buotton from 1 to 6 sequentially...? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
one button for many (macro)
You don't, you create a new macro assigned to that button that runs the 6
macros sequentially. -- HTH RP (remove nothere from the email address if mailing direct) "uriel78" wrote in message ... I've got a sheet in a workbook where I put 6 buttons; each one is assigned to a macro and for my purpouse (and to control that code I write do the right thins) I press them sequentially from 1 to 6 . Now, how can I define another TIA button that "press" buotton from 1 to 6 sequentially...? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
one button for many (macro)
thank you all! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
use macro button to run macro in protected sheet | Excel Discussion (Misc queries) | |||
Can't select macro button after other button is pressed | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming |