Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If it's an ActiveX combobox then catch Enter in its Keydown event like this:
Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) If KeyCode = 13 Then KeyCode = 0 'cancel the keystroke MsgBox "Entered!" 'do something custom End If End Sub Ths Forms combos don't have events like this. HTH. Best wishes Harald "arceaf" skrev i melding ... Hi, I'm trying to program VBA to hit the "Enter" key in a Combo Box, but I don't remember the proper code. Here is what I have: Application.Shapes("ComboBox1") = True Can anyone help me out? Thanks! -- arceaf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
command button and the "enter" and "tab" keys | Excel Programming | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
Combobox: Make "Enter" = Select | Excel Programming | |||
"enter" event of activex combobox? | Excel Programming |