YW3
New member
- Joined
- Jan 17, 2017
- Messages
- 5
- Reaction score
- 0
- Points
- 0
TLDR: I have 2 columns. Column B contains 15 of my option button (Not sure if this'll affect but I just inserted one button and dragged the cell down to get 15 so the name for each option button is different). Column C contains the text values I have (contains VLOOPUP formula to give Yes, No or Perfect).
I want to make the option buttons unclickable (and preferably grayed out) if the value in column C is "No"
All that help I read that makes an unclickable option buttons uses macro. I've never used macros before, so if your solution is via macros, I would appreciate if you could explain it too.
If you have another suggestion instead of option button, go ahead please!
Thanks.
---
The big picture is something like, there are 10 baskets. Depending on what kind of basket the user wants, which s/he fills in the factors in different sheet, to generate the answer in column A.
Based on column A, column C would give the "Perfect" value. Of course, the user could get other similar baskets, which "Yes" comes in at. Then there are baskets that don't fit at all, so "No". Column D would just have the baskets names beside these answers. Eg. C1, Yes, D1, Basket Red; C2, No, D2, Basket Blue; C3, Perfect, D3, Basket Orange. The values in column C changes, the ones in column D doesn't.
I have the option buttons in column B, next to the values (Yes, No, Perfect) so the user can pick whether they want the perfect basket or other similar ones. It's all side-by-side, option button (column B), Yes/No/Perfect (column C), basket names (column D).
That's not where it ends. In column E, I have a table that shows the details of the basket the user would select in column B (the option buttons). That's why I need option buttons, because there can only be one item selected at a time for the table to work.
What I want is to make the option buttons in columnn B unclickable/unable to select if the value in column C gives "No". Or something similar. Cause column E doesn't care for the value in column C, only what the user pick in column B. And I don't want the user to go "Opps, I didn't know those baskets wasn't my type. I could select it, so it's your fault!"
Basically, I want to reduce human error/mistakes.
I want to make the option buttons unclickable (and preferably grayed out) if the value in column C is "No"
All that help I read that makes an unclickable option buttons uses macro. I've never used macros before, so if your solution is via macros, I would appreciate if you could explain it too.
If you have another suggestion instead of option button, go ahead please!
Thanks.
---
The big picture is something like, there are 10 baskets. Depending on what kind of basket the user wants, which s/he fills in the factors in different sheet, to generate the answer in column A.
Based on column A, column C would give the "Perfect" value. Of course, the user could get other similar baskets, which "Yes" comes in at. Then there are baskets that don't fit at all, so "No". Column D would just have the baskets names beside these answers. Eg. C1, Yes, D1, Basket Red; C2, No, D2, Basket Blue; C3, Perfect, D3, Basket Orange. The values in column C changes, the ones in column D doesn't.
I have the option buttons in column B, next to the values (Yes, No, Perfect) so the user can pick whether they want the perfect basket or other similar ones. It's all side-by-side, option button (column B), Yes/No/Perfect (column C), basket names (column D).
That's not where it ends. In column E, I have a table that shows the details of the basket the user would select in column B (the option buttons). That's why I need option buttons, because there can only be one item selected at a time for the table to work.
What I want is to make the option buttons in columnn B unclickable/unable to select if the value in column C gives "No". Or something similar. Cause column E doesn't care for the value in column C, only what the user pick in column B. And I don't want the user to go "Opps, I didn't know those baskets wasn't my type. I could select it, so it's your fault!"
Basically, I want to reduce human error/mistakes.