View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John Howard[_2_] John Howard[_2_] is offline
external usenet poster
 
Posts: 12
Default 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