Run Macro on Enter Key

[Jeckford]

In ThisWorkbook I have the below:

Please Login or Register  to view this content.

And in Module 1 I have the below:

Please Login or Register  to view this content.

This was code provided to me a little while back now and I couldn't ever get it to work, nothing happens when I press enter??? Is it a setting in excel for it not working or is the code wrong? I've attached the workbook.

[Arkadi]

Hmm odd, it works on my end.
you could try moving the workbook_open macro to module 1 with your myMacro sub. Rename workbook_open to auto_open and try that.

Edit: I did have to save your file, enable editing, allow macros, close and open again. But after that it works each time I open it.

[Jeckford]

Hi Arkadi,

Still didn't work. I'm just clicking in a cell then pressing enter, should it work from doing that? Also typing random text in a cell and then pressing enter and nothing happens.

Been online and the examples are all very similar, which is why I think it might be an excel setting problem, but I don't know where to look.

I have no idea why it's not working for me.

[Arkadi]

Yes what you are doing works when I try, in a cell, on a cell, with or without text. Go to the workbook_open macro, and press F8 to step through it. That way you know that at least manually, it ran. Then try to go back to the sheet and try Enter again... any difference? I am trying to establish if it is that the open macro is not running, or if it is that it just doesn't work.

[Arkadi]

By the way, just realized it only works with the numpad enter key for me. Did you try that enter key?

The code is different for "main" enter key, so if you want both detected, try this:

Please Login or Register  to view this content.

[Jeckford]

Oh, didn't try the numpad, but that works.

Is something else typed when using the main enter key? If not, I should be able to get by with the numpad enter key.

Thanks

[Arkadi]

See my edit on my last post for the other enter key.

[Jeckford]

LEGEND!!! Works a treat. Thanks heaps.

[Arkadi]

Glad I could help Jeckford
Thanks for the rep!