Assign button to run macro

  • Thread starter Thread starter jamie85
  • Start date Start date
In ThisWorkbook:

Application.OnKey "{F1}", "UnHide"

Where "F1" is the button you're assigning the macro to and "UnHide" is
the name of the macro. Lookup "OnKey" in VBA Help for a list of the
keys names to use. - Pikus
 
I have this:

Private Sub CommandButton1_Click()
Application.OnKey "{CommandButton1}", "Macro1"
End Sub

However it isn't working. Any idea why?
 
You can use two sort of buttons

View>Toolbars in the Menu bar
Check Forms or Control Toolbox


On a button from the Forms Toolbar you can right click and assign a macro

If you have a button from the Control Toolbox
Press the first button on the Control Toolbox toolbar to go into the design mode
Double click on the button you placed on your worksheet.
The VBA editor will open with this

Private Sub CommandButton1_Click()

End Sub

You can place the code in the event or place the macroname in the event.
Press Alt-q to go back to Excel and press the first button on the Control Toolbox again to exit the design mode
 
CommandButton1 is to a key. If you want a key on your keyboard to call
the macro you need to use the name of that key. Looking up OnKey in
Help will give you a good list to use, though it isn't exhaustive. If
however you want a button to run some code, enter design mode and right
click and select "View Code" from the menu. Just paste the code itself
into the window that pops up or you can call the macro using "Call".

Private Sub CommandButton1_Click()
Call Macro1
End Sub

Let me know if you have any more problems. - Pikus
 
Or you can just insert a picture or drawing which can be formatted not to
print,
and assign a macro to it by right clicking on the border and select "assign
macro............."
The drawing can be a simple square or circle.
regards
Bill K
 
jamie85 said:
*How can i assign a button to run a macro? *
Click to expand...

right click on the grey tool bar at the top and pick the "Forms"
toolbar.

it will open a toolbar with a bunch of things you can add to your
sheet

select the button (looks like a grey rectangle) and then click on the
worksheet and that should add a button to your worksheet.

And it will ask you to assign a macro. Select the one you want with
that button, and then say "OK"

you can change the Caption and size. If this doesn't work let me know,
I just had to figure this out recently.
 
Pikus,
The OP never mentioned the word Key. In his original post he asked about
assigning a macro to a button. You are the one that described how to run a
macro from a shortcut key.
 
Back
Top