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

--
Message posted from http://www.ExcelForum.com

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

"excelnoob " skrev i melding
...
Hello.


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

Thank you for answers.


---
Message posted from http://www.ExcelForum.com/

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/groups?thre...GP11.phx .gbl




--
Regards,
Tom Ogilvy


"Harald Staff" wrote in message
...
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

"excelnoob " skrev i melding
...
Hello.


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

Thank you for answers.


---
Message posted from http://www.ExcelForum.com/