Hello, I have created a list of variables on a different sheet than my main worksheet. My client wants to pick multiple items from this list that I've created using "data validation". How is multiple picks allowed using the drop-down box? Pls detail step by step if possible! Thank you.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Choosing multiple picks within a drop-down box
- Thread starter pkohn
- Start date
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
It isn't really directly possible I'm afraid.
What you could do though is write code that whenever an item is selected it's placed in a cell, then the next item selected is placed in another cell and so on.
What you could do though is write code that whenever an item is selected it's placed in a cell, then the next item selected is placed in another cell and so on.
Upvote
0
Similar threads
- Solved
- Question
