+ Reply to Thread
Results 1 to 5 of 5

Userform Textbox will not allow capital letters after first letter input

  1. 01-20-2014, 09:47 AM #1
    Stratfordoaks
    Stratfordoaks is offline
    Registered User
    Join Date
    11-24-2012
    Location
    Stratford-upon-Avon
    MS-Off Ver
    Excel 2007
    Posts
    89

    Userform Textbox will not allow capital letters after first letter input

    I have a text box that the user inputs names into. The first letter can be entered with a capital letter, but any other letters in the name can only be entered in lower case. The user has just hit the Scottish names such as 'McLeod' and cannot capitalise the 'L'. Any help would be greatly appreciated.

    Regards

    Stratfordoaks
    Reply With QuoteRegister To Reply
  2. 01-20-2014, 09:48 AM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Userform Textbox will not allow capital letters after first letter input

    What code is behind the textbox?
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 01-20-2014, 09:49 AM #3
    Stratfordoaks
    Stratfordoaks is offline
    Registered User
    Join Date
    11-24-2012
    Location
    Stratford-upon-Avon
    MS-Off Ver
    Excel 2007
    Posts
    89

    Re: Userform Textbox will not allow capital letters after first letter input 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 01-20-2014, 09:56 AM #4
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Userform Textbox will not allow capital letters after first letter input

    If you remove that code the user can type what they want.
    Reply With QuoteRegister To Reply
  5. 01-20-2014, 10:07 AM #5
    Stratfordoaks
    Stratfordoaks is offline
    Registered User
    Join Date
    11-24-2012
    Location
    Stratford-upon-Avon
    MS-Off Ver
    Excel 2007
    Posts
    89

    Re: Userform Textbox will not allow capital letters after first letter input

    Thank you Norie. I just realised why I put that code in - to capitalise the first letter!

    Regards

    Stratfordoaks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. UserForm Textbox Format With Capital Letters and Numbers
    By saucey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2012, 11:38 AM
  2. Convert small latter to capital letter in textBox
    By jay11 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2010, 08:40 PM
  3. Only one Capital letter input
    By GoNoGo in forum Excel General
    Replies: 0
    Last Post: 03-27-2009, 06:48 AM
  4. Textbox Capital Letters Only
    By deeppurple247 in forum Excel General
    Replies: 1
    Last Post: 03-12-2007, 04:16 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1