Excel Macro Button

Question

Is there a way to create a button in Excel to trigger a Macro. So say I have a button that says "Start" that I can click to start a Macro instead of using a hotkey.

Jack · Accepted Answer · 2011-07-16 08:34:15Z

7

If you use the 'Forms' toolbar, you will be able to draw a button and assign a macro to it. See here for details.

answered Jul 16, 2011 at 8:34

Jack

3,88815 gold badges46 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

stenci Over a year ago

Sometimes I use the controls as shown in the document, but when things get complex, the controls have problems. I use more and more the technique described here

jonsca · Accepted Answer · 2011-07-16 08:42:01Z

3

Go into the VBA IDE (by clicking to edit your macro or similar). On the left hand side, right click your project, do Insert,User Form. Drag a command button over from the tools, double click it to generate an event handler.

Fill in the code and run the macro to display the form.

answered Jul 16, 2011 at 8:42

jonsca

10.5k26 gold badges56 silver badges63 bronze badges

Collectives™ on Stack Overflow

Excel Macro Button

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related