UserForm Combobox Change Event

[John Howard]

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

 

[Per Jessen]

Hi

I think you should look at the Combobox Exit event.

Best regards,
Per

 

[Jacob Skaria]

John, try placing the code in Exit event

Private Sub ComboBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

End Sub

If this post helps click Yes

 

[John Howard]

Many Thanks Per and Jacob, the Exit event works perfectly for what I need.
It would pay for me to read the manual more closely, RTFM Eh?

 

[Per Jessen]

John, when you are in the codesheet for the userform you have two drop down
fields at the top. Left one show the controls on your userform, right one
show the possible events for the control selected. ( It is the same for
sheet events!)
Nobody can remember all events, but when you see the options you will often
know which to choose.

Hopes this helps.