UserForm Combobox Change Event
 

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

UserForm Combobox Change Event
 

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

UserForm Combobox Change Event
 

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

UserForm Combobox Change Event
 

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
---------------
Jacob Skaria


"John Howard" wrote:

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

UserForm Combobox Change Event
 

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?
--
Regards
John Howard
Sydney, Australia


"John Howard" wrote:

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

UserForm Combobox Change Event
 

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.

---
Per

"John Howard" skrev i meddelelsen
...
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?
--
Regards
John Howard
Sydney, Australia


"John Howard" wrote:

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