Insert a Value when a key is pressed VBA

[Skybluekid]

Hi

Is there a way to insert a value, when a key is pressed, into the active cell in Excel?

What I am looking to do is when the letter "S" is pressed, it inserts "10:00 - 23:00 S" into the active cell?

Thank in advance

 

[davesexcel]

If S is pressed, you would still need to hit enter or do something that enters the S, for anything to happen.

 

[Skybluekid]

Thanks for the pointer. Was trying to make things more complicated that required. All I needed to do was apply a key stroke to the macro.