How do I create a tick box in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top