UserForm TB exit event
On a UF, there are 10 Text Boxes which the user can add text to.
I want the exit event of all the TBs to change the contents to Proper Case, regardless of how it was input.
The user will tab or mouse click to the next tb.
If it has any bearing, 5 of the 10 TBs are in Frame 1 with the rest in Frame 2.
Thanks.
In your UF code, you'll actually want to add one of these for each of your textboxes, it will create the proper formatting in realtime,
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the feedback.
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks