Right now I can only select a item from the list by scrolling the whole list and selecting the item.
Right now I can only select a item from the list by scrolling the whole list and selecting the item.
Yes - that is correct. You are going to need VBA: shall I move the thread for you?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.
Sorry, thanks.
Done. In the meantime, have a look here: https://trumpexcel.com/excel-drop-do...h-suggestions/
If it is on a UserForm use a combo like the attached demo.
This was exactly what I was looking for but I do not see how to create it in my spreadsheet?
see the big yellow banner at the head of the page - how to upload your workbook.
it is far easier to advise when looking at the actual app. - remove sensitive data and leave a couple of dozen rows of the type of data you want to include.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks