Thread: Typeable excel Combobox?

All,

I have created a user interface from a large block of data. In order to find the correct reference number and fill in the interface, I am using a combobox. Once I click on the reference number, it pulls up all the customers information and their order information.

I was wondering if there is some sort of box, I dont know of, that you can start typing the reference number in and it will automatically locate the reference number from that list.

Right now I have to scroll through 500 refrence numbers (they are in numerical order) to find the one I need. Ideally, I could copy and paste number off of an email it woud "snap" to the correct number I could click on. Then the interface would be filled in.

Thanks!

I am using excel 2003. It will only let me open as a read only because it is not compatable with this version of excel. Can you possibly send it with a compatable version?