Run code on keypress enter

[adenjones]

I want to run a simple macro every time someone presses the enter key. I have been trying to do this for a while and I have found examples that should work but non of them seem to do a damn thing. I haven't written macros for excel before so I am guessing that I am missing something fundamental about where I should put my code or something.

Any help greatly appreciated.

Cheers

[Leith Ross]

Hello adenjones,

My guess is Vapor Ware! I don't see line one of code or a workbook. What was the question?

[snb]

You are nor very specific in why you want this, whether it's about entering enter in a cell, a control in a userform, an active-X- control, etc.
Please be more precise and the answers will flow....

[adenjones]

I need the code to run every time someone presses enter in a cell in a worksheet.

I have been trying something similar to this:

Please Login or Register  to view this content.

But nothing at all happens.

[foxguy]

Hi adenjones;

KeyDown and KeyUp only work on objects in a form. There is no equivalent (that I can find) for a spreadsheet. The 2 events that come the closest are
"Private Sub Worksheet_Change(ByVal Target As Range)", but it can't tell whether the user changed the cell or another macro changed the cell
and
"Private Sub Worksheet_SelectionChange(ByVal Target As Range)", but it can't tell if the user changed selection with an enter key, arrow key, or if a macro changed the selection,

[adenjones]

Thanks for the reply. I actually ended up solving it with

Private Sub Workbook_Open()
Application.OnKey "~", "DoSomeThing"
End Sub

[foxguy]

Got to admit, I didn't think of that. Good Show.