Sign in
 
Home20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
Excel checkbox control

Answered Excel checkbox control

  • Thursday, June 21, 2012 1:16 PM
     
     
    Sign In to Vote
    0

    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.

     

All Replies

  • Thursday, June 21, 2012 2:26 PM
     
     Answered
    Sign In to Vote
    1

    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 28, 2012 12:04 PM
     
     
    Sign In to Vote
    0

    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

     
  • Monday, July 02, 2012 8:01 AM
     
     
    Sign In to Vote
    0

    Hi Janet,

    Excellent, thank you for letting us know!

    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com