checkbox1 linked to sheet1 a1
No, it reruns just those values.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"pswanie" wrote in message
...
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" wrote:
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"
|