My Excel 2007 has "auto complete with a drop down list". When I type in the first character, a drop down list appears listing all the entries in that column tha start with that character. I click on one of the entries and the cell is "auto completed" with that entry. Sure is handy. I try to find that functionally in Excell at work, Office Professional 2010, and no bueno for kaki.
C.A. (Ade) Tracy, PE
Hi There,
Welcome to the forum
Please can attach your Excel file as it will be easier and will let us experiment with your data, formulas, codes... Also if you could plot the desired output the way you need it to with some comments and we can try our best to get a solution for you
Thanks,
Bonny Tycoon
**If I was able to help please click the small star icon at the bottom left of my post **
I have the similar question.
I created a LIST (drop down) which reference to a table on a separate worksheet. The list is about 50 entries. This is working fine.
When need to select from the drop down list, it's very troublesome to use the scroll bar up and down everytime. is it possible to type a few characters and it will show the available selection that matches the input?
luvnet,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks