Further to the tutorial "https://www.myonlinetraininghub.com/select-multiple-items-from-drop-down-data-validation-list", I would like to use this in different columns (with different validation lists) in the same sheet. Attach the sample file and please assist with the coding. Thanks!
SC
Hi Stella
From the code, just change DV_Range to New_Range
Sunny
hi Sunny,
Thanks for your reply. My question actually I want to have both DV_range and New_range be available for selection of Multiple items on same sheet and just wonder how to update the coding. If according to your suggestion, will I lose the ability to select multiple items in the DV_range?
SC.
Hi Stella
I misunderstood your question
You can use multiple ranges like below:
If Not Intersect(Target, ActiveSheet.Range("DV_Range, New_Range, Sunny_Range")) Is Nothing Then
Good luck
Sunny
Hi Sunny,
Yes, it works. Thank you so much!
SC.