UserForm Combobox Change Event

  • Thread starter Thread starter John Howard
  • Start date Start date
J

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
 
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
 
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?
 
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.
 
Back
Top