Hi,
I need some advice on a dropdown list that I have in my Excel.
I'm looking for maybe an alternative with some more features?
Let me explain:
I have a dropdown list, with some VBA code I made it a multi select dropdown list, so if you want you can select multiple items, and it will separate them with a comma.
The annoying part is, you can only select one by one and need to open the dropdown for each selection you want to make.
Second thing, it's quite a long list, so to find something it can be difficult
So what I would like is 2 things, being able to select multiple things at once and to be able to search for something?
If been googling a bit, but can't find it, something as the filter window in Excel would be awsome...
Any advice?
Thank you
David
I need some advice on a dropdown list that I have in my Excel.
I'm looking for maybe an alternative with some more features?
Let me explain:
I have a dropdown list, with some VBA code I made it a multi select dropdown list, so if you want you can select multiple items, and it will separate them with a comma.
The annoying part is, you can only select one by one and need to open the dropdown for each selection you want to make.
Second thing, it's quite a long list, so to find something it can be difficult
So what I would like is 2 things, being able to select multiple things at once and to be able to search for something?
If been googling a bit, but can't find it, something as the filter window in Excel would be awsome...
Any advice?
Thank you
David