For checkboxes from the Forms toolbar...

Right click on the checkbox
Select Format Control
On the Control tabCell link
Enter the cell address: =A1

Follow the same method for option buttons.

--
Biff
Microsoft Excel MVP


"Frank Sheeran" wrote in message
...
Thanks; that partly answer the question - that's what I tried but got no
value returned as the True\False were not being read. Now I need to know
how
to link the tick box to the cell.

Thanks

Frank