Help! - Need help with combo box list
 

Hello,

I can use an experts help with this macro. I'm trying to set up userform
with a combo box that lists a names from a predefined range called
"Masterlist". I want to be able to show a simple userform with the list
only. As you enter the name character by character it should take you
automatically to the name in the list as it is being keyed into the combo
box. Once the name is found, the user would hit Enter and it would place the
name on range A1 in the active worksheet. So far, I have the following:

Userform1
ComboBox1

Can someone help with the code?

Thanks,
Roger