On the list when we are typing the first letter then all the data which is starting with that letter has to appear. In data validation how to do this?
Regards
Regina
On the list when we are typing the first letter then all the data which is starting with that letter has to appear. In data validation how to do this?
Regards
Regina
If you already have a list, when you start typing in the next empty row, it will show you the closest word to that start-letter. As you start typing more letters, it will get closer to the word/string you want
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have more than 100 of data in the list box. But it is not appearing when typing the first letter and starts that list. I have to scroll down to select. But i wanted to show or go the letter i type
Here is a link to a thread from a couple of years back that may be relevant to your question.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you JeteMc. The link was useful and i will use the Data Validation method as it suits my requirement. As i am using any forms hence this method is easy.
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks