Navigate in a drop down list

Hi

I have a long drop down list of places in a cell. I want to bring out a particular place name (say India) by typing ' i ' or ' in ' in the cell. Or at least it should show all places starting with I. Is it possible in excel?

Thanks for your help.

Pal

Hi Pal,

Here is a sample that might work for you...

Originally Posted by jeffreybrown

Hi Pal,

Here is a sample that might work for you...

How did you do this? Codes?

Thanks!

Sorry I misread the part where you want to filter in each individual cell and not just a auto filter on the sheet.

You can't do this with Data validation, but an alternative is to Create Dependent Lists. This way you could have one data validation to pick for instance, countries, and then the next data validation would narrow the search to cities within that country.

To do it the way you suggest, I believe it might be able to be done through a combobox, but not really sure as I don't use combobox all that much.

@xov0ct
Yes this is with code. Open the Excel doc and select Alt + F11 which will open the VBE and then double click on the Sheet1 module to sheet the worksheet code.

http://www.rondebruin.nl/code.htm

I'm not realy sure what you are trying to do here, but here are some ideas.

The attached Workbook "PlacesWithVBa.xls" offers two possibilities
Sheet1
Enter a starting letter in Column A (say A2), then confirm this using the "Tick" icon to the left of the formula bar.
If there is a match in Sheet "Lookups" Column A there will now be a validation list in A2 (A2 will be blank)

Sheet2
Select a cell in column A
A UserForm will appear.
Enter a starting letter in the combobox.
This combo should now have a list of the places beginning with your choice, the first found will be displayed.
Select from this list > Press "Enter Selection"

Workbook "Places.xls"
This is as good as I can get without VBa
Enter a letter in Column A the validation list should be in Column B

Both workbooks use non-volatile dynamic named ranges from the Sheet "Lookups", Column B must be sorted A-Z

Thanks, jeffreybrown.