Quick & Easy If You Know

[CraigWolfenden]

Hello All,

Thank you for everyone who has helped me with my current project. It is really appreciated.

I do however have one more question and I promise to leave everyone alone.

How do you allocate a button (from the control toolbox from the toolbar) to run a macro when clicked?

 

[Richard Schollar]

Hi

You need to place the macro name you want to run in the click event of the button. Whilst in Design mode, right-click on the button and select View Code:

Private Sub CommandButton1_Click()
Name_Of_Macro_You_Want_To_Call
End Sub

 

[Papi]

In Excel version 2003 you would Right click with your cursor near the Toolbars at the top of the screen and select the Forms Toolbar. Assuming the macro is already written chose the "Button" Command and drag it onto the screen. The program will then ask you which macro you would like to assign and you click on the one you want.

That is in 2003. What version are you running?

 

[Grege]

silly mee write a response....to bad i hadnt updated and there were alread 4 answers....