add a command button and assugn a macro to it

[sullyman4]

I can get a command button on my worksheet, it does nothing but sit there. I want to assign a macro to it. How is this accomplished

 

[shajueasow]

Right click on th button and select "Assign Macro", and assign the needed macro.

 

[sullyman4]

that is not an option when I right click on it. I have the option of
cut, copy, paste, view code, command button object, grouping, order, format control.

 

[daniels012]

How did you create the button?
Control toolbox
or the Forms toolbar?

Michael

 

[sullyman4]

on my tool bar I have the button, check box , combo box controls.
I click on the button and then click in the worksheet and the button appears. this must not be the way to do it

 

[sullyman4]

Used Controls rather than Forms. Now it works Thanks much

 

[daniels012]

Ok Try to select your button and double click it. This will put you in VBA, for a button from Control Toolbox.
Or try the method described by shajueasow
for a button from the Forms Toolbar.

Michael

 

[Richard Schollar]

Sullyman4

It sounds as if you were in Design Mode whilst you were clicking on the macro - if you have the Controls Toolbar open at the same time as you are clicking on the button, you should be able to turn off Design Mode by clicking the Design button on the toolbar.