Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down menu autocomplete
Excel 2003. drop down menu
how do i turn on the automatic feature that recognizes what i'm going to type....type an "e" and everything starting with e drops below the menu box? -- Olivo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down menu autocomplete
Hi Olivo
Using Data Validation in Excel, you can't. You would need to use a Combo Box. I have written some code to aid navigation to all entries beginning with a letter, using Data Validation. There is an example file you can download at Debra Dalgleish's site http://www.contextures.com/DataValHeadings.zip Also, at Debra's site, you can find information on how to set up and Combo Boxes instead http://www.contextures.com/xlDataVal10.html -- Regards Roger Govier "Olivo" wrote in message ... Excel 2003. drop down menu how do i turn on the automatic feature that recognizes what i'm going to type....type an "e" and everything starting with e drops below the menu box? -- Olivo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
How do I delete some words in autocomplete shortcut menu? | Excel Worksheet Functions | |||
autocomplete from a drop down list | Excel Discussion (Misc queries) |