Hello,
I've been using the autocomplete function of combo box. The function works great for data validation using list of about 20 items or so. I am having problem getting the autocomplete to work when the list gets long. Is there any rules regarding how long the list can be? Or what else could cause for the autocomplete function to be disabled?
Thank you for your help,
Emilie
if you provide the same data file then we can check it out
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks