Execute code from a textbox by pressing Enter. Textbox is em

Tanner · May 9th, 2002, 06:19 PM

I would like to press enter within a text box and have code execute. The textbox is inserted into Sheet1. Not on a user form.

Currently, I enter the text in a textbox and pressing enter does nothing. I placed a button next to the textbox and click it to execute the code. I think this should be simple, but I can't figure it out... Thanks, Stan.

[ This Message was edited by: Tanner on 2002-05-10 08:47 ]

Tom Schreiner · May 9th, 2002, 06:49 PM

Is your textbox on a userform or a worksheet?
Tom

Colo · May 9th, 2002, 08:04 PM

Hi Tanner,
Assuming it is on an userform.
Why don't you use keydown event. Here is sample for you.





Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

  If KeyCode = 13 Then Call YourMacro

End Sub



Private Sub YourMacro()

  MsgBox "it works!"

End Sub

Tanner · May 10th, 2002, 10:37 AM

Thanks for the Solution, Colo. Your solution worked even though the textbox is embedded into sheet 1 and not on a user form.

May 9th, 2002, 08:04 PM	#3
Colo MrExcel MVP Join Date: Mar 2002 Location: Kobe, Japan Posts: 1,420	Hi Tanner, Assuming it is on an userform. Why don't you use keydown event. Here is sample for you. `Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) If KeyCode = 13 Then Call YourMacro End Sub Private Sub YourMacro() MsgBox "it works!" End Sub` __________________ Regards, Masaru Kaji aka Colo - Ex Microsoft MVP Since 2004 -2009

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 06:19 PM	#1
Tanner New Member Join Date: May 2002 Location: Stan Posts: 11	I would like to press enter within a text box and have code execute. The textbox is inserted into Sheet1. Not on a user form. Currently, I enter the text in a textbox and pressing enter does nothing. I placed a button next to the textbox and click it to execute the code. I think this should be simple, but I can't figure it out... Thanks, Stan. [ This Message was edited by: Tanner on 2002-05-10 08:47 ]

May 9th, 2002, 06:49 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Is your textbox on a userform or a worksheet? Tom

May 10th, 2002, 10:37 AM	#4
Tanner New Member Join Date: May 2002 Location: Stan Posts: 11	Thanks for the Solution, Colo. Your solution worked even though the textbox is embedded into sheet 1 and not on a user form.