How do I create a tick box in excel

B

Ben

I want to create a simple tick box in excel beside a list. Effectively the
tick box will either be ticked or not by clicking the mouse on it.
 
J

Jon Peltier

They're called Checkboxes, and there are two types. One is found on the
Forms toolbar (go to View menu > Toolbars, and select Forms), the other on
the Controls Toolbox (View menu > Toolbars, select VBA, then click on the
button with the wrench and hammer). You can link each checkbox to a cell,
which will display TRUE or FALSE depending on whether the box is checked. I
prefer to use the Forms version, but the Controls Toolbox version offers
more formatting options.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top