ONKey

I am trying to write a code using the Onkey for F1.
What I want to do is when the F1 key is pressed it will automatically add the text in textbox602 to the active or selected text box on a user form. Is it possible?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I am moving toward this direction

Please Login or Register  to view this content.

but it is still not working

Ok I am gettign closer I can get the CH16sub to work but the the Inkey feature

Please Login or Register  to view this content.

I have multiple page and frames is there a way I can get this to be unerversial to the whole form?

Here was my solution, although I did not use the onkey I used key down. I also found out that excel is limited with creating shortcut keys due to some focus issues. There was a solution but I did not understand it fully to imlement it.


For each textbox I had to use this code

Please Login or Register  to view this content.

This was the procedure
Note that I have to use a different procedure for every frame I had

Please Login or Register  to view this content.