Use textbox in userform to retrieve data

G'day Excel gurus,

I currently have a Userform I use to retrieve data from a worksheet. I am currenlty using a combo box to enter the search criteria of an employee ID number. As you know, it is a dropdown type box, and will list ALL employee IDs listed on the source worksheet.

When my database gets fully updated, I will have over one hundred employee IDs which means my combo box will list over 100 numbers to choose from.

What I would like to know is... can a 'textbox' be used (ie: manually type a known employee ID), using a VLOOKUP or .find function? I would also like a msgbox to pop up if the empl ID is not found.

Any help is muchly appreciated.

Fogsta