Forum Discussion

Saud's avatar
Saud
Brass Contributor
May 03, 2023

drop list with check box

Hi All   I have a column in an Excel page that has a drop-down list, but the problem is that the options may be more than one. Can I merge the check box with the drop-down list, so that more than o...
developer
Excel
Formulas and Functions
Power BI
MKell099's avatar
MKell099
Copper Contributor

HansVogelaar Piggy-backing off this; hope no one minds.

 

This is great and works beautifully, but I have a question: what if I wanted two different lists to work like this. For instance, range C2:C101 would have the data validation range H2:H10 and range D2:D101 would have the data validation range I2:I15. 

 

So, someone would select option(s) from the drop-down list in C3, and I'd like for them to have the ability to select more than one option from the range of H2:H10. Same thing with the drop-down list in D4. 

 

VBA is not my strong suit, unfortunately. I'm much more proficient in JS, which at least gives me the base to understand what's happening in the code you provided, but not enough to expound upon it. I'd love a little help, if you wouldn't mind!

 

Thanks!

HansVogelaar's avatar
HansVogelaar
MVP
May 09, 2024

MKell099 

The only thing you need to change in the code is the range to be checked:

 

If Intersect(Range("C2:D101"), Target) Is Nothing Then Exit Sub

 

See the attached version.

Resources