View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Hell-fire Hell-fire is offline
external usenet poster
 
Posts: 2
Default Formula for using check boxes

If this has been asked before, sorry for a repeat. In a form I' creating
that will be later imported to Access, some sections I have uses check boxes.
I'm very new to excel, especially using formulas.

For check boxes, like a Yes and No, if a person checks Yes, I would like the
cell to prevent the No box from being check and vice-versa. Also for check
boxes with multiple choices, if they check 3 items, I would like all 3 text's
to appear in the data field that will later be exported to Access. Is there
a way to do this? Thank you