ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lock cell control conditionally? (https://www.excelbanter.com/excel-discussion-misc-queries/126624-lock-cell-control-conditionally.html)

Carl R.

Lock cell control conditionally?
 
I would like to choose or lock an option button selection based upon the
values in another set of option boxes.

Example:

OptionButtons 1, 2 & 3 are in one group
OptionButtons 4 & 5 are in a second group

If OptionButton1 is true, then OptionButton5 must be true
If OptionButton2 is true, then OptionButton4 or 5 can be selected
If OptionButton3 is true, then neither OptionButton4 or 5 can be selected

Any ideas?




All times are GMT +1. The time now is 11:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com