0

I have a dropdown list on excel. When an item is selected it prepopulates cells using VLOOKUP from the table/dropdown list. Now I have modified the VBA to enable multiple selection in the dropdown list from the table, but the cells now don't populate the cells due to multiple selections.

How can I get the cells I need to populate when selecting multiple items? The items chosen will vary, and so will the cells.

I keep attempting at changing the formula, but cannot resolve this issue.

Improve this question
2
Related questions
0
Value retrieval from the Multiple selection dropdown in excel
0
Excal VBA - Vlookup macro dropdown - out of stack space
379
How to remove the default arrow icon from a dropdown list (select element)?
Load 5 more related questions Show fewer related questions

0

Reset to default

Browse other questions tagged or ask your own question.