I have a user-form with a 2-column combo box, and the combo-box opens as
soon as the form is displayed using:

Private Sub UserForm_Activate()
ddCodes.SetFocus
SendKeys ("{F4}")
End Sub

When I select an entry (or type the first letter of an entry and press
Enter), it closes the list, and then I have to press Enter (again) to
trigger the After_Update event (which closes the form and puts the value
into the cells).

I want to only have to only have to select an entry (or type and press Enter
once) to trigger an event - I don't care which event it is - I want to make
it as easy as possible for the users to select items from the list.

However, I can't use the change event, because that is triggered each time a
single character is typed, and sometimes users have to type multiple
characters into the box. Is there a way around this?

Appreciate your help - thanks

Michelle

Have you tried the BeforeUpdate Event?

--JP


On Nov 22, 8:29 am, "Michelle" <mh_londonNOJ...@hotmail.com> wrote:
> I have a user-form with a 2-column combo box, and the combo-box opens as
> soon as the form is displayed using:
>
> Private Sub UserForm_Activate()
> ddCodes.SetFocus
> SendKeys ("{F4}")
> End Sub
>
> When I select an entry (or type the first letter of an entry and press
> Enter), it closes the list, and then I have to press Enter (again) to
> trigger the After_Update event (which closes the form and puts the value
> into the cells).
>
> I want to only have to only have to select an entry (or type and press Enter
> once) to trigger an event - I don't care which event it is - I want to make
> it as easy as possible for the users to select items from the list.
>
> However, I can't use the change event, because that is triggered each time a
> single character is typed, and sometimes users have to type multiple
> characters into the box. Is there a way around this?
>
> Appreciate your help - thanks
>
> Michelle