View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
instructorjml
 
Posts: n/a
Default Making checkboxes mutually exclusive

I have a workbook that has multiple sheets and is using checkboxes that are
checked for a list of questions that have YES, NO, and N/A as possible
responses. (These responses are also tallied on a separate summary sheet.)
Since only one response can be correct, it is possible to make sure that only
one answer can be given for each question? Is there anything that can be done
with an IF statement to make this work?