checkbox1 linked to sheet1 a1

[pswanie]

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"

 

[Bob Phillips]

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]

thanx.. got that sorted out. (there wouldnt be a way to program the checkbox
so that instead of true if ticked it says dayend completed and instead of
false it say dayend incomplete

 

[Bob Phillips]

No, it reruns just those values.

--
---
HTH

Bob


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