Thread: Check box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Check box

If you're using the check box off the FORMS controls toolbar, right click on
the checkbox after placing it in the cell and click the CONTROL tab and enter
the sheet name and cell address Sheet1!A1

If you're using the checkbox on the CONTROLS toolbar after inserting the
check box, right click and select properties. On the ALPHABETIC tab, locate
the LINKEDCELL property and enter the sheet name and cell address.

When done turn design mode off by clicking the button on the CONTROLS
toolbar that has the pencil/ruler/triangle icon.

Hope this helps.

--
Kevin Backmann


"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!