Assign Macro to Command Button in Excel 2002

[DJM1216]

Hi, I'm trying to assign a macro to a command box in Excel 2002.

When I clicked on "help" within excel the directions don't help me. For example, the directions tell me to right click a sizing handle, and select "Assign Macro" from the shortcut list.

When I right click a sizing handle, my only choices are:

Cut
Copy
Paste
Properties
View Code
Command Button Object
Grouping
Order
Format Control

I have the macro recorded, I just want to know how to assign the macro to the button so that once it's pushed, the macro runs.

Thanks in advance for any help you can provide.

 

[Norie]

Which toolbar did you use to create the command button?

It sounds to me that you used the Control Tololbox rather than the Forms one.

If that's the case you don't actually assign a macro.

Select View Code when you right click and the VBA editor should open and you will see something like this:

Private Sub CommandButton1_Click()

End Sub

To use your macro either copy and paste the code from it in here or call it from here.

 

[DJM1216]

That did the trick, thank you!

I did use the control toolbox.

Is there an easier button to format? You mentioned "Forms".

Thanks again.

 

[Norie]

Well the two buttons have there differences.

As to fomatting a button from the Forms toolbar is far more limited than one from the Control Toolbox.

You can change the background and font colour and various other properties.