Hi

I think you should look at the Combobox Exit event.

Best regards,
Per

"John Howard" skrev i meddelelsen
...
I am utilising a UserForm to populate a Sales Recording worksheet.
Existing clients are uniqely listed on a separate sheet accessed by a
Combobox on the UserForm.
The Combobox Change Event verfies that the chosen client already exists in
the Sales Recording worksheet.
Occasionally I need to enter new clients by manually entering into the
ComboBox, but the Change Event fires on the entry of the first character.
Is there a way of delaying the Change Event until the full name is keyed
and
say the <ENTER key or <TAB key is pressed?
Thanks in anticipation
--
Regards
John Howard
Sydney, Australia