Check box value

Hi Bakar.

Try this code:

Please Login or Register  to view this content.

if it's just visual, then try this. if you're using Form Controls, right-click the Checkbox & select Format Control. put Cell Link as:
$A$1

if you're using ActiveX Controls, right-click the Checkbox & select Properties. put Cell Link as:
Sheet1!A1

assuming your information is in B1, put this formula in A1:
=B1<>""

this will work if nobody touches the Checkbox. if they do, the formula in A1 will be gone

nice info.