Forum

How to add Multiple...
 
Notifications
Clear all

How to add Multiple range and Multiple Data Validation List (allow selection of Multiple Items)

5 Posts
2 Users
0 Reactions
296 Views
(@cheungs)
Posts: 3
Active Member
Topic starter
 

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

 
Posted : 05/03/2021 10:21 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Stella

From the code, just change DV_Range to New_Range

Sunny

 
Posted : 05/03/2021 11:44 am
(@cheungs)
Posts: 3
Active Member
Topic starter
 

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.

 
Posted : 06/03/2021 8:39 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Stella

I misunderstood your questionEmbarassed

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

 
Posted : 06/03/2021 9:55 am
(@cheungs)
Posts: 3
Active Member
Topic starter
 

Hi Sunny,

Yes, it works. Thank you so much!

SC.

 
Posted : 07/03/2021 9:26 am
Share: