I have 2 option buttons one called "Min" and one called "Reg". When i click on the "Min" button it inserts "=Settings!M3-J2" into cell K2. When i click "Reg" button it deletes anything that is in cell K2. What i would like to be able to do is if cell K2 does not equal "=Settings!M3-J2" then uncheck "Min" button and check "Reg" button. In ohter words the "Reg" button should always be check unless cell K2 equals "=Settings!M3-J2". Does anytone know if this is possible.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Changine option button based on cell
- Thread starter ira daboy
- Start date
Excel Facts
Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Similar threads
- Replies
- 3
- Views
- 183
- Replies
- 7
- Views
- 403
- Replies
- 9
- Views
- 534
- Replies
- 7
- Views
- 914
- Replies
- 0
- Views
- 157
