Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a macro using a command button
I have created a macro using the Macro Recorder.
I have a command button and I want to run the macro (which is names DATASORT) when I click the button. Please advise how to make this work. Thanks in advance, Travis |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a macro using a command button
This will depend on the type of command button you created. Right-click
your command button. If there is an option to "Assign Macro", then that's how you do it. If not, then click "View Code" Enter this text. Call <your macro name, no brackets HTH, Paul -- "Tdahlman" wrote in message ... I have created a macro using the Macro Recorder. I have a command button and I want to run the macro (which is names DATASORT) when I click the button. Please advise how to make this work. Thanks in advance, Travis |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a macro using a command button
Go to "View" & "Toolbars". Show the forms toolbar.
Click the "button" button. (I know it doesn't make sense, but if you hover your cursor over, it will say "button") You'll get a cursor where you can drag & drop a button. Once you have the button, right click & choose "assign macro". "Tdahlman" wrote: I have created a macro using the Macro Recorder. I have a command button and I want to run the macro (which is names DATASORT) when I click the button. Please advise how to make this work. Thanks in advance, Travis |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a macro using a command button
hi
on the toolbox toolbar, chick design mode. the icon looks like a protractor with ruller and pencil. in design mode right click the button. from the popup, click view code. add this...... Private Sub CommandButton1_Click() call DATASORT End Sub close the vb window. if you need to relocate or resize the button, do so now. click design mode icon again to exit design mode. done. button is live. Regards FSt1 "Tdahlman" wrote: I have created a macro using the Macro Recorder. I have a command button and I want to run the macro (which is names DATASORT) when I click the button. Please advise how to make this work. Thanks in advance, Travis |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a macro using a command button
FSt1 wrote: hi on the toolbox toolbar, chick design mode. --------------------------^^^^^^^^^^^^^^^^^ What version you got, and where can I get one?! ;-) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a macro using a command button
hi
2002 on the menu bar... toolcustomizetoolbarscheck control toolbox regards FSt1 "Bob I" wrote: FSt1 wrote: hi on the toolbox toolbar, chick design mode. --------------------------^^^^^^^^^^^^^^^^^ What version you got, and where can I get one?! ;-) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a macro using a command button
You missed it! You typed "chick design mode".
------------------- -- "FSt1" wrote in message ... hi 2002 on the menu bar... toolcustomizetoolbarscheck control toolbox regards FSt1 "Bob I" wrote: FSt1 wrote: hi on the toolbox toolbar, chick design mode. --------------------------^^^^^^^^^^^^^^^^^ What version you got, and where can I get one?! ;-) |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a macro using a command button
so i can't spell. sigh
"PCLIVE" wrote: You missed it! You typed "chick design mode". ------------------- -- "FSt1" wrote in message ... hi 2002 on the menu bar... toolcustomizetoolbarscheck control toolbox regards FSt1 "Bob I" wrote: FSt1 wrote: hi on the toolbox toolbar, chick design mode. --------------------------^^^^^^^^^^^^^^^^^ What version you got, and where can I get one?! ;-) |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a macro using a command button
It's just funny. Wouldn't be great to have a "chick design mode" in Excel.
;-) -- "FSt1" wrote in message ... so i can't spell. sigh "PCLIVE" wrote: You missed it! You typed "chick design mode". ------------------- -- "FSt1" wrote in message ... hi 2002 on the menu bar... toolcustomizetoolbarscheck control toolbox regards FSt1 "Bob I" wrote: FSt1 wrote: hi on the toolbox toolbar, chick design mode. --------------------------^^^^^^^^^^^^^^^^^ What version you got, and where can I get one?! ;-) |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a macro using a command button
Not to worry, please review for humor aspect!
FSt1 wrote: so i can't spell. sigh "PCLIVE" wrote: You missed it! You typed "chick design mode". ------------------- -- "FSt1" wrote in message ... hi 2002 on the menu bar... toolcustomizetoolbarscheck control toolbox regards FSt1 "Bob I" wrote: FSt1 wrote: hi on the toolbox toolbar, chick design mode. --------------------------^^^^^^^^^^^^^^^^^ What version you got, and where can I get one?! ;-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you remove a macro command button? | Excel Discussion (Misc queries) | |||
Command Button to run a Macro | Excel Worksheet Functions | |||
Command Button for Macro on a Toolbar | Excel Discussion (Misc queries) | |||
Run Macro from Command Button | Excel Discussion (Misc queries) | |||
Destroy command button with a Macro? | Excel Discussion (Misc queries) |