Run a macro when 'Enter' is pressed?

**jcup** · 09-28-2007, 09:51 AM

Is it possible to run a macro when the 'Enter' key is pressed? I know you can assign shortcut keys, but they usually involve some combination of 'Ctrl' + a key.

I have a form made, and would like to execute the macro when just 'Enter' is pressed.

Thank you.

**WinteE** · 09-28-2007, 10:49 AM

Hi jcup,

I've made you a sample in the attached file.

Erik

**royUK** · 09-28-2007, 02:11 PM

If you mean a UserForm then use the KeyUp event

Private Sub CommandButton1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
     MsgBox "You pressed enter"
End Sub

Run a macro when 'Enter' is pressed?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Run a macro when 'Enter' is pressed?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions