Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking the ENTER key to a Button on a Form?
Hi folks,
I'm creating a User Form in Excel. It includes a Text Box and a number of buttons. When the user types into the Text Box and (instinctively) presses ENTER, is there a way to simulate the clicking of a button? In other words, can ENTER - when pressed from the Text Box - be used to trigger the code behind a button? Many thanks, Jason Paris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking the ENTER key to a Button on a Form?
Hi,
Your textbox name is TextBox1, your button name is btnOK: Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) If KeyCode = 13 Then btnOK_Click End Sub Private Sub btnOK_Click() MsgBox "OK launched by ENTER" End Sub Regards, Manu/ "Jason Paris" a écrit dans le message de news: ... Hi folks, I'm creating a User Form in Excel. It includes a Text Box and a number of buttons. When the user types into the Text Box and (instinctively) presses ENTER, is there a way to simulate the clicking of a button? In other words, can ENTER - when pressed from the Text Box - be used to trigger the code behind a button? Many thanks, Jason Paris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to make the enter button work as regular enter | Excel Discussion (Misc queries) | |||
Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
Command Button vs Form Button | Excel Programming | |||
enter button in vb | Excel Programming | |||
Command Button vs Form Button | Excel Programming |