How to move the textbox cursor from textbox1 to textbox2 using the arrow key?

[kjy1989]

So i have 9 textboxes in a userform that is in a 3x3 format, the textboxes in my userform are positioned as follows:

textbox1 textbox2 textbox3
textbox4 textbox5 textbox6
textbox7 textbox8 textbox9


How do i make so like for example i click textbox5, and i press an arrow key, it will jump to the textbox where it is located like
up key = textbox2
down key = textbox 8
right key = textbox6
left key = textbox4

how do i do this?

[:) Sixthsense :)]

Up and Down arrow do it nicely

[kjy1989]

Up and Down arrow do it nicely

are you being sarcastic because i did something wrong in the format of my thread? If so I apologize.

If you're not being sarcastic though, up and down arrows doesnt do it.

[:) Sixthsense :)]

Set the Tab order according to your need.

[HaHoBe]

Hi,m :) Sixthsense :)

waiting for your example for Textbox1 and Textbox9...

Ciao,
Holger

[:) Sixthsense :)]

waiting for your example for Textbox1 and Textbox9...

....................................

[HaHoBe]

Hi, :) Sixthsense :)

thanks for your sample - I certainly would never have been able to do it.

Besides I think we understood the sample given by TO quite diffferently. The original was with the active TB being the middle one (TB5). Your solution will work with some limitations as only up and down key work until they reach the border (which is fine for the sample given) while left and right key on my Excel wonīt.

Letīs take TB6 and check there. No problem for up, down and left but maybe about right as TB6 is on the far right side of the Form. From what I understood it would have been TB 4 for the right key while using the TAB order it could have been TB7. Same with TB9. Left and up key donīt present any problem but right could be TB7 and down TB3.

Anyhow: OP has to be more specific about what is wanted for the border TBs or if any action is wanted there at all.

Ciao,
Holger

[:) Sixthsense :)]

May be OP should go for application.OnKey method