Hi all,
I have a drop down list in excel. What do I need to do so that it will automatically take me to the closest/best label on the list when I type just a few first letters?
Thanks all,
VBisgreat
Hi all,
I have a drop down list in excel. What do I need to do so that it will automatically take me to the closest/best label on the list when I type just a few first letters?
Thanks all,
VBisgreat
Are you talking about the MatchEntry property of the combobox?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
I'm not sure what it is, whatever can help me get the the label on my drop down list when I type in a few letters instead of scrolling down and find it on the list. Thanks.
Look at the MatchEntry property of the combobox. Read the help on it by pressing F1, and let me know if that doesn't resolve your issue.
For form control direction: I tried to follow the direction and got stuck after the: 4. On the Developer tab, in the Controls group, click Properties .
Last edited by VBisgreat; 04-06-2011 at 05:38 PM.
Personally, I only use ActiveX controls so I don't know much about form controls.
It still doesn't work for me. Sorry I'm pretty new in using excel formula. Thanks for your help.
If you use a ComboBox from the Control ToolBox the MatchEntry property is set by Default to auto complete.
Here's a quick example that also uses a Dynamic Named Range to fill the Combobox, the control will try to match as you type.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
this may work --
Thanks RoyUK.
Grizzly6969: That's great, can you show me step by step how to get there? I got a similar list and when I follow your instruction the fomula didn't work. Thanks!!!
Nevermind, I think it's working now. Thanks all
I really appreciate your helps.
Last edited by VBisgreat; 04-07-2011 at 10:33 AM.
My drop down no longer clickable after I save it and reopen it...
you had not named the range thats why it vanished
check this out
this file should help with your validation
I am having the same issue as VBisgreat. I have named ranges as I should, but every time I exit and then re-open the file the "Smart" drop-down list quits functioning and I have to re-activate the Data Validation (no changes - just open DV, select apply to all like cells and click OK.. Any clues why? (I use Excel 2007). This is a template for use by many so I finally just assigned a macro to a button that re-activates the Data Validation. My version of Duct-tape and bailin' wire, which works but certainly is not optimal.
By this we can search the list starting with that letter that i entered but can we get the drop down if the data contains that letter not as first letter.Please help me..its urgent.Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks