Thread: Check box
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Check box

One of the Checkbox Properties is Linked Cell. Type in the cell you wish to
have linked to the checkbox (my personal preference is to link to the cell
the checkbox is actually in, then change the formatting of the cell to
Font-White).
This will populate the cell with either TRUE or FALSE depending on the
status of the checkbox. Then you can reference the cell for your needs.

Hope this helps.
--
John C


"Gravy Man" wrote:

Can you get an Excel check box to link to another cell/worksheet? I tried
this, but it just returns a "0", and doesn't acknowledge the check or check
box. I wonder if I have to just use a standard cell & manually type an "X"
to get a link to another cell/worksheet.

Thanks!