+ Reply to Thread
Results 1 to 3 of 3

Display Text String in Uppercase on a Userform InputBox

  1. 04-30-2015, 03:34 AM #1
    HangMan
    HangMan is offline
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Display Text String in Uppercase on a Userform InputBox

    Is there a way to display a Text String in Uppercase on a Userform even if the user enters it in lowercase? So if the user enters 'go swimming' and this is captured as MyTextString, when displayed on the InputBox, it is dispalyed as 'GO SWIMMING'

    Please Login or Register  to view this content.
    Many thanks
    Reply With QuoteRegister To Reply
  2. 04-30-2015, 03:40 AM #2
    michson
    michson is offline
    Registered User
    Join Date
    09-10-2014
    Location
    Matrix
    MS-Off Ver
    2010
    Posts
    70

    Re: Display Text String in Uppercase on a Userform InputBox

    Yes, convert you string with Ucase function e.g. 
    Please Login or Register  to view this content.
    (*) Reputation points appreciated.
    excelbs.tk
    Reply With QuoteRegister To Reply
  3. 04-30-2015, 03:57 AM #3
    HangMan
    HangMan is offline
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Re: Display Text String in Uppercase on a Userform InputBox

    Perfect, thank you...
    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. How to delimit only uppercase string
    By CorinthianVortex in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2013, 10:17 AM
  2. Check to see if a string is all in uppercase?
    By pablowilks in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-12-2012, 05:52 AM
  3. [SOLVED] Display certain text from a string
    By matthewdbeard in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-06-2012, 01:51 PM
  4. InputBox-ow to have a user input text in a inputbox
    By noodle48 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2011, 08:17 AM
  5. Inputbox Uppercase
    By deeppurple247 in forum Excel General
    Replies: 1
    Last Post: 03-13-2007, 09:19 AM

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