Can I use a userform/combobox for both selecting and adding?

[chuckf201]

Hi to all,
Complements to this website for giving me the answers I seek consistently.
My question is very basic but want to follow accepted procedures and practices.
My userform contains name, address, and email.
Name is a combobox and contains over 4000 names, other fields are textboxes. I can select name and other fields populate - no prob.
My problem is I want to use the same combobox to add names to my list, but each keystroke triggers "Private Sub cmbMemberName_Change()" event.
Am I using the wrong event for manual input or am I using the wrong field (combo vs. listbox).

Thanks

 

[My Aswer Is This]

Try this:
Private Sub ComboBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

 

[chuckf201]

Great - thanks. Works like a charm.
Chuck

 

[My Aswer Is This]

edit

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

Great - thanks. Works like a charm.
Chuck

 

[My Aswer Is This]

Glad it worked for you.

Great - thanks. Works like a charm.
Chuck