Hello There,
I have a defined fields (Field1, Field2, 3...) in a worksheet. I would like the OnKey to fire when the User presses ENTER, TAB, SHIFT + TAB, UP ARROW, DOWN ARROW and navigate to the concerned fields accordingly.
eg. If the User is on Field 1. On key press ENTER, the focus should go on Field 2.
This is the first time I am trying to see it working. I came to knowthat onkey will do the trick.
Could you please assist in how this can be achieved? I have attached a sample workbook for your reference.
Many thanks & regards,
Don
I have a defined fields (Field1, Field2, 3...) in a worksheet. I would like the OnKey to fire when the User presses ENTER, TAB, SHIFT + TAB, UP ARROW, DOWN ARROW and navigate to the concerned fields accordingly.
eg. If the User is on Field 1. On key press ENTER, the focus should go on Field 2.
This is the first time I am trying to see it working. I came to knowthat onkey will do the trick.
Could you please assist in how this can be achieved? I have attached a sample workbook for your reference.
Many thanks & regards,
Don