Detecting Enter key in Textbox

[AlexanderBB]

I've tried looking for Asc 13 in both KeyUp and Keypress events but it is ignored. This isn't how it should be is it?

Doesn't show in the Exit event either. How an you tell if a user has pressed Enter, or instead has clicked away from the text box?

 

[Logit]

.
This macro is for a textbox located on a sheet:

Option Explicit


Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    
    If KeyCode = vbKeyReturn Then
        MsgBox "Hi !"
    End If


End Sub

 

[AlexanderBB]

You won't believe this.. it didn't work, so I added a line Debug.print keycode with the windows showing to see results... and then the ENTER key started working.

 

[Logit]

Interesting