View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Moving between textboxes

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/