Combo boxes within Excel

Hi,

I come from a software company that is totally against the use of MS Access & I’m trying to create a s/sheet (that would be sooo much easier in Access) that logs all of our support calls.

We have a massive number of codes to identify the various parts of our software application & rather than have my users freeform type in fields, I’d much rather they have to select from a drop down list.

So far I’ve set-up validations to do this & it’s OK, but it does not provide the additional functionality that a combo box does with the ability to type a couple letters in & search based on that.

If someone could assist me with this it would be greatly appreciated.

Regards,

Michael