What kind of checkboxes. ActiveX from the control toolbox toolbar or excel
checkboxes from the forms toolbar. When do you want them to return Y or N?
When the control is checked. If so, then without code, link the checkboxes
to the cell over which they are located and which will contain True or
False. Then in another cell, put in a formula like =if(b9,"Y","N") where
B9 is the linked cell.

Otherwise you would need to not linke the checkbox and use event code to
place the Y or N in the cell.

--
Regards,
Tom Ogilvy

"gareth" wrote in message
...
I have several check boxes on a sheet. I want to check
these boxes and return a 'Y' if it has been selected and
a 'N' if it hasn't.

Thanks in advance.

gareth