I want to insert a check box to assign a macro.

Asked By 40 points N/A Posted on -
qa-featured

I would like to know something about macro in Microsoft excel. I have heard that check boxes can create in excel and assign a macro. Can someone explain me how to insert a check box to assign a macro?

SHARE
Answered By 0 points N/A #144638

I want to insert a check box to assign a macro.

qa-featured

It is able to insert a button from Microsoft excel easily. I will tell you the way that you should follow.

First you should have the Developer tab in excel toolbar. In order to add it first clicks on the windows mark at the left upper corner and click on Excel options.

Developer Tab

Then tick on the “show developer tab in the ribbon” check box and click ok.

Developer tab

Then to add a button click on the developer tab and click on t insert control as shown in the picture.

Insert Control

Now click on the button icon and just draw it in the excel sheet.

Insert Button in Excel

Now if you want to assign a macro right click and click on “assign macro”.

Login/Register to Answer

Related Questions