View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Linking check boxes so if one is true the other shows false

I have two "yes or no" check boxes but they are both linked to the same cell
so both read the same (checked or unchecked). Is there a way to reverse one
so that it indicates "checked" when the source cell is false so they will
work together? I tried going to design mode and selecting "group" but the
options were gray-scale so not available (don't know why). I tried using
option buttons but was limited on the number. Thanks in advance.