View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do I create a tick box in excel

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Ben" <Ben @discussions.microsoft.com wrote in message
...
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.