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?
- Login or Signup Now to post comments
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?
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 tool bar. 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”