PDA

View Full Version : Solved: select other object when a textbox is full



circaa
06-09-2006, 07:11 AM
Hi guys !

My textbox has a maxlenght, when this maxlenght is reached, I want another textbox to be automatically selected and ready to accept text.

thanks

lucas
06-09-2006, 07:24 AM
Attached is an example from mvidas. Its pretty self explanatory but if you have questions post them here.
I use this a lot

mvidas
06-09-2006, 07:34 AM
Thanks Steve, I actually don't even remember doing that, but I'll take your word for it :) Looks like something I might do though

circaa - The key settings for those are the TabOrder (starting with zero), MaxLength, and AutoTab=False.
If you're referring to textboxes on the worksheet, they don't have a taborder, I don't remember if there is a way to do it or not. Using a userform is much easier, as demonstrated there.

Matt

circaa
06-09-2006, 07:42 AM
Solved

Thanks Steve !

lucas
06-09-2006, 07:50 AM
Thanks goes to Matt. He's the one who worked this out for us. I know it was yours Matt as your name was in the doc properties which I removed before posting.......I'm glad it served your purpose.