walking menu
Is there a way in Excel when you are using data entry from a drop down list
to start typing and have the menu show the list options, instead of having to scroll through EVERYTHING? For example, if I had a list with names on it, can I start typing "gram" and have the menu show the first entry with "g", and then go to the next entry with "gr", etc. etc thanks |
walking menu
If the dropdown was created from DataValidationList
DV list dropdown has no autocomplete feature. You will have to use a ComboBox to achieve this using VBA See Debra's Contextures site for how-to. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Sun, 30 Sep 2007 12:38:01 -0700, Grams wrote: Is there a way in Excel when you are using data entry from a drop down list to start typing and have the menu show the list options, instead of having to scroll through EVERYTHING? For example, if I had a list with names on it, can I start typing "gram" and have the menu show the first entry with "g", and then go to the next entry with "gr", etc. etc thanks |
walking menu
I went to the site you referenced and, Oh MY!...I found a better way to do
it. I used the validation method to limit the list to only what matched the criteria I wanted. Saves a ton of time. THIS IS A GREAT SITE....I bookmarked it for future reference. The instructions are so easy to follow and the download samples are awesome! THANK YOU SO MUCH "Gord Dibben" wrote: If the dropdown was created from DataValidationList DV list dropdown has no autocomplete feature. You will have to use a ComboBox to achieve this using VBA See Debra's Contextures site for how-to. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Sun, 30 Sep 2007 12:38:01 -0700, Grams wrote: Is there a way in Excel when you are using data entry from a drop down list to start typing and have the menu show the list options, instead of having to scroll through EVERYTHING? For example, if I had a list with names on it, can I start typing "gram" and have the menu show the first entry with "g", and then go to the next entry with "gr", etc. etc thanks |
walking menu
Thank you for the feedback.
Debra will be pleased to see your glowing critique of her site. We all use it regularly. Gord On Sun, 30 Sep 2007 14:32:02 -0700, Grams wrote: I went to the site you referenced and, Oh MY!...I found a better way to do it. I used the validation method to limit the list to only what matched the criteria I wanted. Saves a ton of time. THIS IS A GREAT SITE....I bookmarked it for future reference. The instructions are so easy to follow and the download samples are awesome! THANK YOU SO MUCH "Gord Dibben" wrote: If the dropdown was created from DataValidationList DV list dropdown has no autocomplete feature. You will have to use a ComboBox to achieve this using VBA See Debra's Contextures site for how-to. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Sun, 30 Sep 2007 12:38:01 -0700, Grams wrote: Is there a way in Excel when you are using data entry from a drop down list to start typing and have the menu show the list options, instead of having to scroll through EVERYTHING? For example, if I had a list with names on it, can I start typing "gram" and have the menu show the first entry with "g", and then go to the next entry with "gr", etc. etc thanks |
All times are GMT +1. The time now is 04:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com