Hello, I would like to do the following. If cell A1 contains "Hello" and if the focus is on A1 and if the Enter key is pressed, then the focus should go to B2 and a MsgBox should appear. I think this can be done with key events, something like OnKeyDown, but how do I tell it I want the event only be triggered by the Enter key? Thanks, Liglin

Showing Answers 1 - 4 of 4 Answers

sc

  • Jun 8th, 2007
 

Trap Enter with ASC code 13 not 32 (which is ASCII code of space)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions