MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro button ...

Posted by Adam a.k.a. Yellow Wizard on August 23, 2001 4:33 AM

How do i link a macro button to a macro command?


Posted by Robb on August 23, 2001 4:55 AM


Depends which type of button you are using.

If it is a button from the Forms Menu, you right click on it and choose "Assign Macro" from the menu.

If it is a CommandButton from the Control Toolbox, display the Control Toobox and click the Design button (top left - set square etc). Then, when you right click on the button a menu will appear.
On this menu, choose View Code - the code window will display.
Top right drop down will probably be showing "Click".
Drop the list to see the events for which you may enter code.

This help?