Make Dependent Drop Box Searchable

[DawnA530]

I may be shooting for the mirror here, but some of my dependent drop boxes have 100+ options in it, so it would be nice to be able to have a search function when using the form's drop down menu without the user having to click on the drop down menu and then start typing - its very counterintuitive to the people who have tested my sheet so far. All of the searchable drop box solutions I found don't use dependent lists, and I can't find a way to make them work with the way I have it set up.

Is there a VBA solution to make the employee drop box searchable with the way I have my dependent drop lists set up? Do I need to start over and try to come up with a pure VBA solution? What would be best at this point?

Searchable Box.JPG

Since I can't upload the sheet (I keep getting an upload failed notice), here is the code:

Please Login or Register  to view this content.

I am playing with something like this from StackOverflow, but I seem to be misapplying it:

Please Login or Register  to view this content.

I also found some autocomplete ones, but I am not sure where to put them with the Case/Select functions:

Please Login or Register  to view this content.

[davesexcel]

Hello, how are you trying to attach the workbook?

[DawnA530]

I am trying to attached through the Manage Attachments link below
Upload Failed.JPG