Hi everyone.
I would really appreciate any help on this.
Please see attached.
I have created a searchable drop down list (cell D2 in Searchable sheet). When I enter a search string, I have to click on the down arrow button of to see the search results.
Is there a way so that after typing the search string and pressing [Enter], the list opens to show the search results?
I'm guessing this would involve application.onkey but I'm lost on how to use it. So basically, it's something like .. if cell D2 is edited (ie. a search string is inputted) and the Enter button is pressed, then open the list box. How would this be coded in VBA?
Any suggestions would be much appreciated.
Bookmarks