View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default How to insert Checkbox in excel to simply click and tick it?

If you're using Excel 2007, you need to have access to the Developer Tab - in
Office button/Excel Options/Popular, the 3rd checkbox is Developer tab. Once
you see the tab, in the Controls group, you'll see Insert dropdown - the top
section is your forms controls (including checkbox) and the bottom section is
your activeX controls (including checkbox). I recommend forms control
checkbox.
By the way, to know if it's clicked or not, you should use the format
control & assign the checkbox to a cell; then if it's checked, the cell will
have TRUE, else it'll have FALSE.

"Keegan" wrote:

I just wanted to know how I can create a Check Box in Excel where I can
simply chick the box and it gets Ticked.