executing a macro when the Enter key is pressed in a textbox

[ScubaStevo]

I want to execute a macro when the user presses the enter key rather than needing clicking on an OK button or pressing the enter key several times to get to the OK button and pressing enter on that.

The OnChange and OnExit events arent suitable for this, is there a way I can use the OnKeyPress to return the enter when pressed key and execute the macro then?

Thanks

Steve

 

[Lightning]

Use the Form's KeyDown event to trap for the Enter Key being pressed.

You also need to set the form's Key Preview event to YES for this to work correctly.

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    If KeyCode = vbKeyReturn Then
        'Do Whatever
    Else
        'Do Something Else
    End If
End Sub

HTH
Lightning

 

[ScubaStevo]

thanks heaps she works a treat