Forum

Create multiple sel...
 
Notifications
Clear all

Create multiple select dropdown lists with randomization

3 Posts
2 Users
0 Reactions
84 Views
(@leea)
Posts: 2
New Member
Topic starter
 

Hi there,

I would like to create multiple select dropdown lists for:

  1. More than one multiple select dropdown list in the same worksheet (more than 1 data validation column per worksheet)
  2. Data validation lists saved in a different worksheet (not active/current worksheet)
  3. Data validation lists which automatically randomizes/shuffles values (I've added formulas to shuffle the values and not sure if it works 100%)

I have tried to add the above requirements but the code does not run.

Would really appreciate your help. I am using Microsoft 365 - PC.

Regards,

Lee

 
Posted : 29/05/2021 12:33 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi Leea,

All I changed in your code is this:

If Not Intersect(Target, Test_list.Range("Test_1, Test_2, Test_3")) Is Nothing Then

To:

If Not Intersect(Target, Me.Range("A2:C14")) Is Nothing Then

 
Posted : 01/06/2021 2:05 pm
(@leea)
Posts: 2
New Member
Topic starter
 

Hi Catalin,

Thank you, I am not all that familiar with VBA so this has helped so much.

 

The above is working as it should for those workbooks where two columns are being referenced.

If Not Intersect(Target, Me.Range("I5:I502", "N5:N502")) Is Nothing Then

 

I then used the following for 3, non-consecutive columns and it worked.

If Not Intersect(Target, Me.Range("I5:I502", N5:N502, "Q5:Q502")) Is Nothing Then

 

Thank you again!

Regards,

LeeA

 
Posted : 03/06/2021 1:21 am
Share: