Moving between textboxes

[excelnoob]

Hello.


I'm making a blank with textboxes. When i'm done feeding th
information I need to, I'd like move on to the next textbox using Ta
or Enter key, preferrably Tab key. Is that possible? If is, how?

Thank you for answers

 

[Harald Staff]

Hi

I suggest you use a Userform for this, not an empty worksheet. Then tabbing
is the default behavior.

If not you must code each and every one's KeyDown event, and if Keycode = 9
then activate the next box.

HTH. Best wishes Harald

 

[Tom Ogilvy]

There is some sample code for Haralds method at this posting by Rob Bovey:

See Rob Bovey's posting on a method to do this:

http://groups.google.com/[email protected]




--
Regards,
Tom Ogilvy

Hi

I suggest you use a Userform for this, not an empty worksheet. Then tabbing
is the default behavior.

If not you must code each and every one's KeyDown event, and if Keycode = 9
then activate the next box.

HTH. Best wishes Harald