Hi there,
I would like to create multiple select dropdown lists for:
- More than one multiple select dropdown list in the same worksheet (more than 1 data validation column per worksheet)
- Data validation lists saved in a different worksheet (not active/current worksheet)
- 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
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
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