Link the checkbox to a cell via the checkbox properties, and check the cell
value with a simple IF test.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pswanie" wrote in message
...
how will i get a value in sheet1 cell a1 when putting a tick in checkbox1?

if checkbox1 got tick in cell a1 should read "dayend failed"