Thursday, June 21, 2012 1:16 PM
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 2:26 PM
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
- Marked As Answer by Rex ZhangModerator Thursday, June 28, 2012 4:24 AM
Thursday, June 28, 2012 12:04 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.
Monday, July 02, 2012 8:01 AM