How to simulate the ENTER KEY being pressed (ie trigger Enter Key event)

Hi there,

I have defined an event listener for the ENTER KEY as shown in the code below. Instead of relying on my user to hit the enter key, I want to "simulate" or "trigger" the enter key being pressed in VBA code. Does anyone know how to do this?

Please Login or Register  to view this content.

.
.
I attempted to find out for myself by recording a macro whilst hitting the enter key. What I don't like about using "" is that it hardcodes both the name of my excel workbook as well as the name of my Sub. Is there a better way?

Please Login or Register  to view this content.

.
.
The best or "cleanest" I can fathom is the code below... but still, surely there is a simple way to just "fire the enter key" being pressed?

Please Login or Register  to view this content.

Thanks in advance,
Michelle