Eric,

You can do a Yes/No data validation in a single cell, but it sounds like you
want to have Yes in one cell and No in another. If this is the case, you can
use a spreadsheet change event to monitor when the Yes or No selection has
changed. I'm also unclear on the distinction between whether you want to use
checkboxes or data validation or a combination of both.
--
Regards,
Eddie
http://www.HelpExcel.com


"Eric" wrote:

Does anyone have any suggestions on how to create (Yes/NO) check boxes in
Excel cells? With data validation on selection, if yes is clicked, then no
will be unclicked automatically, if no is clicked, then yes will be unclicked
automatically.
Does anyone have any suggestions
Thanks in advance for any suggestions
Eric