Calling a Macro just with the enter key.

[claudiodeviaje]

hi there...

I'm making a small VB macro in Excel und I need some help.

Is it possible to call a macro when the cursor is in Cell x,y and the ENTER key is pressed?

If the cursor is in another cell, the enter key should work normally.

Thank you!

claudio

 

[joerd]

You can set up a Worksheet_Change or Worksheet_SelectionChange event macro, and see if it suits your needs.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.