Log In
Register
Home
New Member
May 29, 2021
Offline
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
See Answer
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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
Answers Post
New Member
May 29, 2021
Offline
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
1 Guest(s)
