Hello Everyone,
I am using the VBA code form the following website to achieve auto complete in a combo box with data validation:
http://www.contextures.com/xlDataVal10.html
Is it possible to make the combo box a filter as well as autocomplete? I'd like to type in any part of a word, and have it return all of the potential matches in the range it references, narrowing down as I type more of the word.
I've attached the sample file with the code for reference.
Thanks!
Last edited by atdemeo; 05-20-2016 at 02:55 AM.
I don't know why Microsoft added the functionality to Access but not Excel.
The main issue with Excel is that it doesn't know anything is happening until you leave the cell. A long time ago I played with the buffer, but you have to put Excel into a special mode to intercept the buffer to get the keystrokes as you type them. I can't recall what I had to do. All I remember is that it was a hassle and made it more difficult to enter data.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
This is an example of a combobox that 'search as you type':Originally Posted by atdemeo
The sample workbook:
Please Login or Register to view this content.
Amazing. Thank you!!!
You're welcome & thanks for the feedback
I'm back!
Would you be able to combine the combo box you supplied in your post with the script I have in the first post? I'm looking to get the search as you type box to appear on double click in a cell. I tried to combine it myself, but the code is a little over my head.
Also, the search as you type only works if you type the items in the list in the correct order. Keeping with your example, how would I get the combo box to show Atlanta by typing lanta instead of Atla?
Thanks,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks