none
Excel checkbox control

    Question

  • I have a form with several checkboxes.  I have a situation where I need to show that if one checkbox is checked, then this next one cannot be, and visa versa.

    Say A1 is checked, B1 cannot be checked.  If A1 is not checked, B1 can be.

    I have linked the checkboxes to a cell.  Any help would be appreciated.

    Thursday, June 21, 2012 1:16 PM

Answers

  • Hi Janet,

    In that case, option buttons are your better choice, as they are mutually exclusive be design.


    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com
    Thursday, June 21, 2012 2:26 PM

All replies

  • Hi Janet,

    In that case, option buttons are your better choice, as they are mutually exclusive be design.


    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com
    Thursday, June 21, 2012 2:26 PM
  • I used your suggestion with the option buttons and that worked very well.  I was able to group them in sections and now my form does exactly what I need it to do.

    Thanks


    Janet Conway

    Thursday, June 28, 2012 12:04 PM
  • Hi Janet,

    Excellent, thank you for letting us know!


    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com
    Monday, July 02, 2012 8:01 AM