+ Reply to Thread
Results 1 to 5 of 5

VB - Making first letters of words uppercase

  1. #1
    Registered User
    Join Date
    10-04-2009
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    77

    VB - Making first letters of words uppercase

    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
    Last edited by Smurlos; 03-06-2010 at 10:40 AM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VB - Making first letters of words uppercase

    Hello ,

    You can invoke the Proper worksheet function from VBA.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    08-21-2008
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Office 2007
    Posts
    255

    Re: VB - Making first letters of words uppercase

    To return user logon id
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    10-04-2009
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    77

    Re: VB - Making first letters of words uppercase

    thanks for all your help :-)

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VB - Making first letters of words uppercase

    Hello Smurlos,

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1