No, it reruns just those values.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"pswanie" <(E-Mail Removed)> wrote in message
news

37811C3-7273-456F-A38E-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:4798A2A9-866A-4714-95A9-(E-Mail Removed)...
>> > 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"
>>
>>
>>