text box to perform action when i press enter

[vino.spider]

hi friends,
i need to insert an textbox in excel and when i key some value and when i press enter key it should perform some action...

i have tried with keyascii ..

private sub textbox1_keypress(keyascii as integer)
if keyascii=13 then
msgbox"text1.text"
end if
end sub

 

[sijpie]

I am not sure if yo can do this in VBA. under VB you can do something like this, so perhaps it is possible. See these links


http://msdn.microsoft.com/en-us/library/system.windows.forms.control.keypress.aspx

 

[vino.spider]

it is not working ...
can you plz explain how to perform...

 

[Ruddles]

Maybe:-

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
  If KeyCode = 13 Then MsgBox TextBox1.Text
End Sub

This is for an ActiveX textbox - I can't seem to place a Form textbox on my worksheet at the moment.

 

[vino.spider]

thank you

 

[Ruddles]

I can't seem to place a Form textbox on my worksheet at the moment.

Ignore this comment: an idiot crept into the office and typed it whilst I wasn't looking!

 

[Ruddles]

thank you

Does it work for you?