Hi All
I was wondering, is there a way to do the following:
Make the first letter of a word typed into a textbox in a Userform, turn uppercase automatically so that if they typed "smith" it turns to "Smith" when they click on another field?
Is there also a way to ensure that another field, every character becomes uppercase? i.e. say they typed "aaaa123" it would turn to "AAAA123"?
When we're logged in at work, it obviously has our username, the staff id which is our log in id etc. Is there a way i can extract these values in excel so that I can take the person's name into the spreadsheet just from their being logged into the system? (We use Windows XP)
Many thanks for help in advance
Bookmarks