CODEWITHSUNDEEP
excelvba
Michael Downey
Michael Downey

Reputation: 687

Excel Macro Button

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.

Upvotes: 2

Views: 462

Answers (2)

jonsca
jonsca

Reputation: 10381

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.

Upvotes: 3

Jack
Jack

Reputation: 3878

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

Upvotes: 7

Related Questions