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


<jashby2@gmail.com> wrote in message
news:1128432004.746611.288640@g44g2000cwa.googlegroups.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
>