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

Asked By Steve Randle 40 points N/A Posted on - 08/20/2012

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?

• Status: Open
• Question Views: 925
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Geisha Nitta 0 points N/A #144638

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

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.

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

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

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

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

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/20/2012
• Question Category: MS Excel