[SOLVED] Return alt-enter when enter is pressed in a specific cell

Perhaps you could use a TextBox object from the Drawing toolbar and place it on the worksheet over your cell. Assign a macro to it to paste the text in your cell or do what you need done.

Okay - figured it out after a night's sleep:

I changed the worksheet_change sub:

Please Login or Register  to view this content.

It looks for a switch that I created below.

and I added this:

Please Login or Register  to view this content.

Application.onkey will run a macro (it has to be public and in a module) when a particular key is pressed.

Then added this to a module:

Please Login or Register  to view this content.

This will cause the boolean to switch if the tab key was pressed

Finally, I put in a code to remove the onkey watch when I leave the page:

Please Login or Register  to view this content.