No really practical to do it with code I wouldn't think. Link the cell
underneath the checkbox. Then in the cell where you want to see yes/no, put
in a formula

=if(A1,"Yes","No")

where A1 is the linked cell.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Hello,

I want to change the "TRUE" and "FALSE" labels that pop-up in the cell
linked to the checkbox with "YES" and "NO," respectively. I am using
checkboxes from the control toolbar.

These are the TRUE/FALSE labels that appear when you tick the checkbox.
I'm sure its one or two lines of code, just can't seem to find it.

Thanks for the help,
jashby2