Adding a macro to a Command Button

[Mabocat]

I created a Command Button on one page of a spreadsheet and managed to give it a Title so how do I link a macro that I have already created to this button ?
I an using Excel 2010

Ron

 

[Mabocat]

All done OK, I used a standard text box.

Ron

 

[Peter_SSs]

If you wanted to know the answer to your original question, tell us whether the Command Button was from the Form Controls or the ActiveX Controls section.

 

[Mabocat]

As it turns out Peter, it was from ActiveX Controls section.

Ron

 

[Peter_SSs]

.. it was from ActiveX Controls section.

Then the process would be.
- On the Developer ribbon tab enter 'Design Mode' via the button of that name.
- Right click the Command Button and choose "View Code".
- That should take you to the worksheet's module in the vba window & present you with code like

Private Sub CommandButton1_Click()

End Sub

- Just enter the name of your macro between those lines. So if your macro was called Do_Stuff it would become

Private Sub CommandButton1_Click()
  Do_Stuff
End Sub

- Back at the worksheet, exit Design Mode by clicking that ribbon button again.