Running a Macro

K

Keith

Can anybody tell me how to run a macro from a command
Button.

Excel help says to select the button then right click and
select Assign Macro from the shortcut menu, but the menu
dosn't have such an option.

I am running Excel XP
 
J

JWolf

If you add a button using the Forms toolbar, then you can select a macro
through the shortcut menu. The macro would exist in a standard module.
The button will have a default name like Button 1.
If you add a button using the Controls Toolbox toolbar, then it has it's
own code module, available through the shortcut module. VBA associated
with this button needs to be in it's code module. The button will have
a default name like CommandButton1.
 
A

Arvi Laanemets

Hi

There is a difference, do you use a button from Control Toolbox or Forms
Toolbar. For first, you select from dropdown menu 'View code' - an empty
OnClick event is created, and you can edit it. With another, you are asked
for procedure yo want the button to be assigned to, when you create button,
but you can assign the procedure later too. But you must have a macro
present in VBA module anyway - you can't assign non-existing macro to
command button from Forms toolbar.
 
Top