Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a button in spreadsheet
i have just built a macro. how do i create a button in the spreadsheet to
run the macro? for instance, press button and the macro will run, putting in the answer in the field next to the button? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a button in spreadsheet
in Office 2007, use the Developer Tab, insert either a form control or active
x control, and assign the macro to it. it's been a while since i have had to do it in Office 2003, so i cannot help in that. jat "Ann" wrote: i have just built a macro. how do i create a button in the spreadsheet to run the macro? for instance, press button and the macro will run, putting in the answer in the field next to the button? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a button in spreadsheet
hi
if 2003 then on the menu bar.... viewtoolbarscontrol toolbox. (you can use the forms button but i recommend the control toolbox button.) mouse over the controls untill you find command button. click it then click the sheet and drag to size the button on the sheet. right click the button and click view code. Private Sub CommandButton1_Click() call yourmacroname End Sub close the vb editor right click the button again. click properties. here you can set button caption, background color, font color and other properties. when done close the property box. mouse over the control toolbar again and click exit design mode. close the toolbar. Button should be live and ready to go. regards FSt1 "Ann" wrote: i have just built a macro. how do i create a button in the spreadsheet to run the macro? for instance, press button and the macro will run, putting in the answer in the field next to the button? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a button in spreadsheet
here's the vb editor:
Private Sub ReportCompleted_Click() Call Macro3 End Sub when i click the button, it does nothing, i get the 4 arrow when i hover over it. help. "FSt1" wrote: hi if 2003 then on the menu bar.... viewtoolbarscontrol toolbox. (you can use the forms button but i recommend the control toolbox button.) mouse over the controls untill you find command button. click it then click the sheet and drag to size the button on the sheet. right click the button and click view code. Private Sub CommandButton1_Click() call yourmacroname End Sub close the vb editor right click the button again. click properties. here you can set button caption, background color, font color and other properties. when done close the property box. mouse over the control toolbar again and click exit design mode. close the toolbar. Button should be live and ready to go. regards FSt1 "Ann" wrote: i have just built a macro. how do i create a button in the spreadsheet to run the macro? for instance, press button and the macro will run, putting in the answer in the field next to the button? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a button in spreadsheet
got it, it works.
"Ann" wrote: here's the vb editor: Private Sub ReportCompleted_Click() Call Macro3 End Sub when i click the button, it does nothing, i get the 4 arrow when i hover over it. help. "FSt1" wrote: hi if 2003 then on the menu bar.... viewtoolbarscontrol toolbox. (you can use the forms button but i recommend the control toolbox button.) mouse over the controls untill you find command button. click it then click the sheet and drag to size the button on the sheet. right click the button and click view code. Private Sub CommandButton1_Click() call yourmacroname End Sub close the vb editor right click the button again. click properties. here you can set button caption, background color, font color and other properties. when done close the property box. mouse over the control toolbar again and click exit design mode. close the toolbar. Button should be live and ready to go. regards FSt1 "Ann" wrote: i have just built a macro. how do i create a button in the spreadsheet to run the macro? for instance, press button and the macro will run, putting in the answer in the field next to the button? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a button in spreadsheet
This is fabulous - Thank you!
One additional question - is there a way to avoid creating the button in every spreadsheet I use? I work with a lot of reports - so I can't use the "save template" option. Any suggestions are much appreciated! "Ann" wrote: got it, it works. "Ann" wrote: here's the vb editor: Private Sub ReportCompleted_Click() Call Macro3 End Sub when i click the button, it does nothing, i get the 4 arrow when i hover over it. help. "FSt1" wrote: hi if 2003 then on the menu bar.... viewtoolbarscontrol toolbox. (you can use the forms button but i recommend the control toolbox button.) mouse over the controls untill you find command button. click it then click the sheet and drag to size the button on the sheet. right click the button and click view code. Private Sub CommandButton1_Click() call yourmacroname End Sub close the vb editor right click the button again. click properties. here you can set button caption, background color, font color and other properties. when done close the property box. mouse over the control toolbar again and click exit design mode. close the toolbar. Button should be live and ready to go. regards FSt1 "Ann" wrote: i have just built a macro. how do i create a button in the spreadsheet to run the macro? for instance, press button and the macro will run, putting in the answer in the field next to the button? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create an option button in a spreadsheet? | Excel Worksheet Functions | |||
Create a button | Excel Discussion (Misc queries) | |||
Create Print Button on spreadsheet | Excel Worksheet Functions | |||
how do i create a button within a spreadsheet | Excel Discussion (Misc queries) | |||
How do I create a print button? | Excel Worksheet Functions |