In my form, I have a combobox which includes a list of names harvested
from several worksheets and allows the user to select one.
I'd like for the combobox to operate like this:
* Allows user to pick a name from the list (preferably with match first
letter option)
* Allows user to enter a name, and once done, add that to the combobox
list and sort it.

I find that the combobox_change event keeps firing, so I end up with a
list of partial names.
If I add "Roger" to the list, i'll also end up with "r", "ro", "rog" and
"roge" in the list.

Thanks, Darren.