Posted to microsoft.public.excel.programming

Karen Agostinho Karen Agostinho is offline

external usenet poster

Posts: 2

UpCase in userform

Good Morning NG,
I have a text box that I receive user input for states.
I have the MaxLenght set to 2 so only things Like CA, NV, AZ can entered,
but sometimes the user wants to put in ca, nv, or az.
How can I set the text box to automatically capitalize the letters for the
users in VBA code
Thanks

Karen

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
UserForm	bgkgmg	Excel Worksheet Functions	1	February 26th 09 04:25 PM
UserForm	FSt1	Excel Worksheet Functions	0	February 26th 09 02:00 AM
UserForm	grahammal	Excel Discussion (Misc queries)	15	April 10th 06 06:01 PM
Userform	Jeff	Excel Discussion (Misc queries)	0	February 6th 06 09:30 PM
Userform	John Wilson	Excel Programming	2	August 1st 03 06:33 PM

All times are GMT +1. The time now is 08:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us