Moving between textboxes

E

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
 
H

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
 
T

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


Harald Staff said:
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
Click to expand...
 
Top