Redefining Keyboard using VBA

[AliCat]

Hi folks,

I'm entering times on a sheet and to save my little fingers, I want to redefine the ENTER key on the numerick keypad to give me a COLON ), but only in the specific workbook.

I've looked up the Help!!! and come away with the following code,

Sub OldKey()
Application.OnKey "{ENTER}", "NewKey"
End Sub

Sub NewKey()
Application.SendKeys (":")
End Sub

but it's not working.

Where am I going wrong.???

Help appreciated, thanks.

 

[HarryB]

Probably there is nothing wrong, but you did not realise that you defined the {ENTER} of the numeric keypad. Use "~" for the normal ENTER.