If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
quick selection drop down list
Hello every one,
I use quite a lot of drop down lists in a work book and some of them are pretty long. The question is: is there a way to pouch in the first letter of a word ( the list is arranged in alphabetical order) so as the list goes to that postion? Thank you for any suggestion. 68magnolia71 |
#2
|
|||
|
|||
No, you need a combobox for this.
-- HTH RP (remove nothere from the email address if mailing direct) "68magnolia71" wrote in message ... Hello every one, I use quite a lot of drop down lists in a work book and some of them are pretty long. The question is: is there a way to pouch in the first letter of a word ( the list is arranged in alphabetical order) so as the list goes to that postion? Thank you for any suggestion. 68magnolia71 |
#3
|
|||
|
|||
If this is a data validation dropdown, it doesn't support autocomplete.
If you can use programming, there are instructions here for adding a combobox from which you can select one of the values from the data validation list. In the combobox, you can enable autocomplete: http://www.contextures.com/xlDataVal11.html 68magnolia71 wrote: Hello every one, I use quite a lot of drop down lists in a work book and some of them are pretty long. The question is: is there a way to pouch in the first letter of a word ( the list is arranged in alphabetical order) so as the list goes to that postion? Thank you for any suggestion. 68magnolia71 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
Hello Debra and Bob,
Thank you for your answers. Unfortunately I'm not accustumed with programming, VBa and other comboboxes ( I wonder if comboboxes exist in the french version). The drop down list in the "name bar" ( left top of screen) is longer than my drop list and still readable. I didn't see it before but the question has been asked many times before and I think the problem has to be adressed to by Microsoft like the automatic height of murged cells and a couple of others. 68magnolia71 "Bob Phillips" wrote: No, you need a combobox for this. -- HTH RP (remove nothere from the email address if mailing direct) "68magnolia71" wrote in message ... Hello every one, I use quite a lot of drop down lists in a work book and some of them are pretty long. The question is: is there a way to pouch in the first letter of a word ( the list is arranged in alphabetical order) so as the list goes to that postion? Thank you for any suggestion. 68magnolia71 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drop Down list (list data in another worksheet) | AC | General Discussion | 4 | September 16th, 2004 01:53 PM |
drop down list in Excel | Kimla | General Discussion | 4 | September 12th, 2004 09:49 PM |
Drop Down List Questions | Tagg Bowman | General Discussion | 2 | September 2nd, 2004 05:49 PM |
excel 97 vba - need to associate values with drop down list choice | chief | General Discussion | 15 | July 23rd, 2004 11:52 PM |
Drop Down List / Count Function | Mukiwa | Worksheet Functions | 2 | July 7th, 2004 11:56 PM |