Create a Macro Button

This post will guide you how to create a custom macro button in Excel. How do I insert VBA button into a cell and then linking it to a macro in Excel. How to assign a macro to a control button in your worksheet.

Create Macro Button

You need to enable developer tab in your excel ribbon, and then insert a button into a cell from form controls. Let’ see the below detailed steps.

#1 go to DEVELOPER tab, click Insert command, and select the button icon from the Form Controls section.

create macro button1

#2 draw a button into a blank cell, the Assign Macro dialog will open.

create macro button2

#3 select one Macro from the list, click OK button. Or you can press New button to create a new macro.

#4 let’s see the result.

create macro button3

Leave a Reply