Hi,

Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
If KeyAscii = 13 Then
msgbox 123
End If
End Sub

When I press ENTER button there is no msgbox.
How can I make this code work?

Thanks,

Private Sub TextBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)
If KeyCode = 13 Then
MsgBox "123"
End If
End Sub



"ermeko" wrote:

Hi,

Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
If KeyAscii = 13 Then
msgbox 123
End If
End Sub

When I press ENTER button there is no msgbox.
How can I make this code work?

Thanks,

This code does not work.

also how can I make Textbox1.setfocus.
It does not work.

"Steven" wrote:


Private Sub TextBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)
If KeyCode = 13 Then
MsgBox "123"
End If
End Sub



"ermeko" wrote:

Hi,

Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
If KeyAscii = 13 Then
msgbox 123
End If
End Sub

When I press ENTER button there is no msgbox.
How can I make this code work?

Thanks,

It does, I tried it and it is fine.

TextBox1.SetFocus

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"ermeko" wrote in message
...
This code does not work.

also how can I make Textbox1.setfocus.
It does not work.

"Steven" wrote:


Private Sub TextBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)
If KeyCode = 13 Then
MsgBox "123"
End If
End Sub



"ermeko" wrote:

Hi,

Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
If KeyAscii = 13 Then
msgbox 123
End If
End Sub

When I press ENTER button there is no msgbox.
How can I make this code work?

Thanks,