View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Userform - Move to next textbox field by hitting enter instead

The alternative (subclassing) requires at least two lines of individual code
for every box too, so it's about as simple as this gets. So yes, but also
no, not write, copy-paste it and replace each single "TextBox1" with each
unit's name. C'mon, once done it's done.

Best wishes Harald

"TimT" skrev i melding
...
Harald,
That sounds well and good but I have almost 50 or so fields, so I would

need
to write that for each field?