Guidance for drop down list

[jaydeepvyas2005]

Dear Chandoo,


I have one below query:


A1-INDIA

A2-INDONESIA

A3-AMERICA

A4-AHMADABAD

A5-AFRICA


I have a list in "A" column & I want to above listed name in "B1" cell as a list when i start to type listed first alphabet so that time that have to show me all listed name which is started what i have typed.


Example:


When we type any alphabet in Google, it's shows many names in same typed alphabet.

 

[dan_l]

That would be cool if you figure something out. Maybe you could do something cute with named ranges? It would still show formulas and other named ranges though.

 

[NARAYANK991]

Hi Vyas ,


I doubt that what you want can be done by a simple drop-down validation list , since when you enter anything in a cell , you immediately enter EDIT mode , and no other evaluation is possible till you complete data entry in that cell.


What you want can be done by using a combobox and VBA ; is this acceptable ?


An alternative is to use the "Enable AutoComplete for cell values" under the Advanced section in Excel options ; of course , this will auto complete only when you enter enough letters to differentiate one option from another ; in the example you have given , to differentiate INDIA from INDONESIA , you will have to enter 4 letters , while to differentiate any one of AMERICA , AHMEDABAD or AFRICA , you will have to enter 2 letters.


Narayan

 

[Mohd Hafizan Noh]

hi all,

is there any idea to share regarding this matter. i also having the same problem. Hoping someone could help me...