Problem with combo-box

[asgerali]

I have 3 drop downs in my sheet.
The first one is a form control (drop down list) which has 3 entries. Depending on what is selected in the first drop down, a macro is run to populate the second.

The second one is an activex control (combo box). I need a combo box because the list is going to be very long (probably 500+ entries) and the user needs to be able to type in the first few characters to minimise the scrolling effort.
Now, depending on what is selected here, a macro needs to run to populate the third drop down.

The problem I'm facing is this. The only way to assign a macro to a combo box is to code it in the worksheet. When I do it as a Combobox_Change() function, it runs everytime the user types even one alphabet. (The macro is a little slow, so it's not preferable)
If I use the Combobox_Click() function, the macro runs only if the user clicks on it. Typing it out doesn't do the trick.

Is there a way the combobox can detect an 'Enter' being pressed? If there is some other type of control that I could use, that is fine too. As long as the basic requirement of being able to type in the drop down is satisfied.

Thanks in advance

[royUK]

Maybe you could use the Lost_Focus event

Private Sub ComboBox1_LostFocus()
'macro name here
End Sub

[asgerali]

Doesn't work
LostFocus() works when the user clicks somewhere outside the combo box. Pressing the enter key doesn't trigger it.

[Leith Ross]

Hello asgerali,

You can use the KeyUp event to detect the Enter key. Here is an example that beep when the enter is pressed.

Private Sub ComboBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
  If KeyCode = 13 Then
     Beep
  End If
End Sub

[asgerali]

Hi Leith,

I know I'm a little late in saying this, but thanks a million! You can't imagine how much of a help you've been. I guess I forgot in the jubiliation after i saw that it worked :D

In retrospect, I feel kinda stupid not having figured it out myself.

Thanks