Linking a Macro to a Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having a brain cramp.
How do I trigger an existing macro with a button object?
I am using the Control Toolbox to create the button, then I'm lost.
Thanks.
 
You may be better to use a button from the Forms toolbar, and then you can
right-click the button and assign your macro to it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Use the 'Forms' Toolbar rather than the 'Controls' toolbar, when you create
your button a dialog will appear asking you whic macro you want to associate
with the button.

HTH

Neil
www.nwarwick.co.uk
 
Thanks to both who replied.

Neil said:
Use the 'Forms' Toolbar rather than the 'Controls' toolbar, when you create
your button a dialog will appear asking you whic macro you want to associate
with the button.

HTH

Neil
www.nwarwick.co.uk
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Button 2
losing command button functionality 4
Assigning a macro to a command button 1
Assign a macro to a command button 4
Command Button for Macro on a Toolbar 7
Macro Buttons 3
Getting control toolbox button to record a macro. 2
How to create control button on worksheet: Forms v. ActiveX feature? 2

Back
Top