Drop down list enables select checkboxes [closed]
I have a drop down list of the 50 US states in my excel sheet. When I select New York, I want three checkboxes be enabled to select. When I select any of the other 49 states, I only want one of those three check boxes selected. How can I get my checkboxes to be conditional of a drop down list value?
excel vba excel-vba
asked Nov 13 '18 at 19:09
BetOBetO
244
closed as too broad by Scott Holtzman, chris neilsen, Mathieu Guindon, Cindy Meister, K.Dᴀᴠɪs Nov 14 '18 at 23:47
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I have a drop down list of the 50 US states in my excel sheet. When I select New York, I want three checkboxes be enabled to select. When I select any of the other 49 states, I only want one of those three check boxes selected. How can I get my checkboxes to be conditional of a drop down list value?
excel vba excel-vba
asked Nov 13 '18 at 19:09
BetOBetO
244
closed as too broad by Scott Holtzman, chris neilsen, Mathieu Guindon, Cindy Meister, K.Dᴀᴠɪs Nov 14 '18 at 23:47
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
You'll probably need aWorksheet_Changeevent.
– dwirony
Nov 13 '18 at 19:10
You can do this via a cell reference on your checkbox without vba. In the cell reference type a formula like=IF(A1="NY",TRUE,FALSE)where A1 = the 50 state drop down list.
– Scott Holtzman
Nov 13 '18 at 19:14
add a comment |
I have a drop down list of the 50 US states in my excel sheet. When I select New York, I want three checkboxes be enabled to select. When I select any of the other 49 states, I only want one of those three check boxes selected. How can I get my checkboxes to be conditional of a drop down list value?
excel vba excel-vba
asked Nov 13 '18 at 19:09
BetOBetO
244
I have a drop down list of the 50 US states in my excel sheet. When I select New York, I want three checkboxes be enabled to select. When I select any of the other 49 states, I only want one of those three check boxes selected. How can I get my checkboxes to be conditional of a drop down list value?
excel vba excel-vba
excel vba excel-vba
asked Nov 13 '18 at 19:09
BetOBetO
244
asked Nov 13 '18 at 19:09
BetOBetO
244
asked Nov 13 '18 at 19:09
BetOBetO
244
asked Nov 13 '18 at 19:09
BetOBetO
244
asked Nov 13 '18 at 19:09
BetOBetO
244
244
closed as too broad by Scott Holtzman, chris neilsen, Mathieu Guindon, Cindy Meister, K.Dᴀᴠɪs Nov 14 '18 at 23:47
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as too broad by Scott Holtzman, chris neilsen, Mathieu Guindon, Cindy Meister, K.Dᴀᴠɪs Nov 14 '18 at 23:47
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
You'll probably need aWorksheet_Changeevent.
– dwirony
Nov 13 '18 at 19:10
You can do this via a cell reference on your checkbox without vba. In the cell reference type a formula like=IF(A1="NY",TRUE,FALSE)where A1 = the 50 state drop down list.
– Scott Holtzman
Nov 13 '18 at 19:14
add a comment |
You'll probably need aWorksheet_Changeevent.
– dwirony
Nov 13 '18 at 19:10
You can do this via a cell reference on your checkbox without vba. In the cell reference type a formula like=IF(A1="NY",TRUE,FALSE)where A1 = the 50 state drop down list.
– Scott Holtzman
Nov 13 '18 at 19:14
You'll probably need a
Worksheet_Change event.– dwirony
Nov 13 '18 at 19:10
You'll probably need a
Worksheet_Change event.– dwirony
Nov 13 '18 at 19:10
You can do this via a cell reference on your checkbox without vba. In the cell reference type a formula like
=IF(A1="NY",TRUE,FALSE) where A1 = the 50 state drop down list.– Scott Holtzman
Nov 13 '18 at 19:14
You can do this via a cell reference on your checkbox without vba. In the cell reference type a formula like
=IF(A1="NY",TRUE,FALSE) where A1 = the 50 state drop down list.– Scott Holtzman
Nov 13 '18 at 19:14
add a comment |
1 Answer
1
active
oldest
votes
When you say "drop down list" I assume you mean a cell with data validation and that your "checkboxes" are checkbox form controls.
If the cell with data validation is A1 and the Check Boxes are linked to cells B1, C1, and D1 you would simply place the following in each cell:
B1 (all states) =IF($A$1<>"",TRUE,FALSE)
C1 and D1 (only NY) =IF($A$1="NY",TRUE,FALSE)
edited Nov 13 '18 at 21:25
SJR
12.1k31217
answered Nov 13 '18 at 19:31
MattMatt
111
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
When you say "drop down list" I assume you mean a cell with data validation and that your "checkboxes" are checkbox form controls.
If the cell with data validation is A1 and the Check Boxes are linked to cells B1, C1, and D1 you would simply place the following in each cell:
B1 (all states) =IF($A$1<>"",TRUE,FALSE)
C1 and D1 (only NY) =IF($A$1="NY",TRUE,FALSE)
edited Nov 13 '18 at 21:25
SJR
12.1k31217
answered Nov 13 '18 at 19:31
MattMatt
111
add a comment |
When you say "drop down list" I assume you mean a cell with data validation and that your "checkboxes" are checkbox form controls.
If the cell with data validation is A1 and the Check Boxes are linked to cells B1, C1, and D1 you would simply place the following in each cell:
B1 (all states) =IF($A$1<>"",TRUE,FALSE)
C1 and D1 (only NY) =IF($A$1="NY",TRUE,FALSE)
edited Nov 13 '18 at 21:25
SJR
12.1k31217
answered Nov 13 '18 at 19:31
MattMatt
111
add a comment |
When you say "drop down list" I assume you mean a cell with data validation and that your "checkboxes" are checkbox form controls.
If the cell with data validation is A1 and the Check Boxes are linked to cells B1, C1, and D1 you would simply place the following in each cell:
B1 (all states) =IF($A$1<>"",TRUE,FALSE)
C1 and D1 (only NY) =IF($A$1="NY",TRUE,FALSE)
edited Nov 13 '18 at 21:25
SJR
12.1k31217
answered Nov 13 '18 at 19:31
MattMatt
111
When you say "drop down list" I assume you mean a cell with data validation and that your "checkboxes" are checkbox form controls.
If the cell with data validation is A1 and the Check Boxes are linked to cells B1, C1, and D1 you would simply place the following in each cell:
B1 (all states) =IF($A$1<>"",TRUE,FALSE)
C1 and D1 (only NY) =IF($A$1="NY",TRUE,FALSE)
edited Nov 13 '18 at 21:25
SJR
12.1k31217
answered Nov 13 '18 at 19:31
MattMatt
111
edited Nov 13 '18 at 21:25
SJR
12.1k31217
edited Nov 13 '18 at 21:25
SJR
12.1k31217
edited Nov 13 '18 at 21:25
SJR
12.1k31217
12.1k31217
answered Nov 13 '18 at 19:31
MattMatt
111
answered Nov 13 '18 at 19:31
MattMatt
111
answered Nov 13 '18 at 19:31
MattMatt
111
111
add a comment |
add a comment |
You'll probably need a
Worksheet_Changeevent.– dwirony
Nov 13 '18 at 19:10
You can do this via a cell reference on your checkbox without vba. In the cell reference type a formula like
=IF(A1="NY",TRUE,FALSE)where A1 = the 50 state drop down list.– Scott Holtzman
Nov 13 '18 at 19:14