Creating a yes/no checkbox for Excel

[dawnh44]

Does someone have a sample code that I can use to create a checkbox for yes/no in Microsoft Excel?

I would really appreciate it.

Thank you.

Dawn

 

[JeanetteM]

Right click on the tool bars. Choose 'Control Toolbox'. This will bring up another tool bar. On this you can choose the 'check box' or other style. Move your cursor over the worksheet. Your cursor will become a cross. Click and drag to the size you want and release the mouse button. You know have a checkbox.

Hope this is what you are looking for.

~JM

 

[dawnh44]

Hello,

Thank you for the information, but the check box is not working correctly. I've added to my worksheet, but I'm unable to check or uncheck it. Is there some code that I have to add to it?

Thank you for any help you are able to provide.

Dawn

 

[JeanetteM]

Once your checkbox is there, make sure the design view is disabled (turned off). To do this:

click the design button on the 'control toolbox' toolbar.

Let me know if this works for you. It should.

 

[dawnh44]

It works perfectly!!!!!!!!!! Thank you so much for your help. Your the best.

Dawn