I have a somewhat complicated sheet set up with a LOT of dropdowns. They are just regular form control dropdowns, NOT ActiveX or data validation dropdowns. The contents of these dropdowns are somewhat lengthy, and I've been asked to find a way so that people can quickly jump to the name in the dropdown they want by typing the first few letters.

I do know that this is easily done with ActiveX control dropdowns, but unfortunately our sheet uses ordinary form controls instead. Is there any way to accomplish this? VBA solutions welcome; I was just hoping I wouldn't have to start all over from scratch using ActiveX controls.