Searchable Dropdowns Combo Box

Happy Friday! I'm working on a Travel Reimbursement form (attached). I'm trying to get the address cells to show a short list of addresses once the user starts typing in the combo box. It works pretty well for the first one (I would like go be able to use down arrows or the tab key to go down the list). However, for the second combo box (different name), when I try and type in an address it only pulls up the first one I already entered in the box above it. I'm using the searchable list tab to make difference helper columns to come up with the short list. Any help would be appreciated!

Natalie

I don't want to do that unless it shows the options and one can be selected without using the mouse.

You current workbook setup crashes Excel when I use tab key to remove focus from first combobox.

No mouse use?

Just set workbook option->Advanced-> Uncheck "After pressing Enter, move selection" or set that option using VBA.

Then type search string in cell. Hit enter, Alt+down arrow key. To show dropdown menu and select from list.

Here's sample using your file.