Application.Onkey Assistance

[BigBas]

Guys:

I'm drawing a blank right now. A few months ago I setup a workbook to track some purchases. In the date column (column 1), I built in code so that pressing the UP arrow would automatically incrememnt the date by one, and the down arrow would decrease the date by a day. I know for a fact that I used an Application.OnKey bit of code, but I cannot for the life of me remember what the code was, and where I placed it. To make matters worse, I cannot find the workbook itself to remind me.

I THINK this is the code I had, but obviously it doesn't work:

Please Login or Register  to view this content.

Can anyone help me get the ball rolling again? I appreciate it.

[royUK]

Does this help?

http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

[SuitedAces]

Please Login or Register  to view this content.

place the following in a seperate module

Please Login or Register  to view this content.

[BigBas]

Roy:

I appreciate the link. I had already checked there though.

Suited:

I probably should have mentioned that I was already able to employ the OnKey code using a macro. But, I am almost possible that the last time I did it, I didn't have it refer to a macro. I may be wrong though.


One follow up question: is there anyway to have the OnKey code refer to the PLUS key (on the numeric key pad). I can get it to work with the regular PLUS sign, but not the one on the numeric keypad.

Thanks for the help.

[SuitedAces]

Roy:

I appreciate the link. I had already checked there though.

Suited:

I probably should have mentioned that I was already able to employ the OnKey code using a macro. But, I am almost possible that the last time I did it, I didn't have it refer to a macro. I may be wrong though.


One follow up question: is there anyway to have the OnKey code refer to the PLUS key (on the numeric key pad). I can get it to work with the regular PLUS sign, but not the one on the numeric keypad.

Thanks for the help.

To the best of my knowlege need to call a seperate macro with the Onkey method, you cannot simply attach a line of code to the Onkey method as you have done.
I tested the code I posted for you , are you having any trouble with it ?

Offhand I do not know how to refer to the plus key on the numeric keypad.
Probably best to make a seperate post.

[BigBas]

Suited:

The code works just fine. I guess I was just wondering if the OnKey method could run code without calling a module.

Either way, thanks for your time.

[SuitedAces]

You're welcomed and if recall correctly being application level you want to make sure to return those keys to a normal state before opening other workbooks.

Please Login or Register  to view this content.