+ Reply to Thread
Results 1 to 5 of 5

Change input text into upcase using macro

  1. #1
    Registered User
    Join Date
    12-22-2012
    Location
    Basel
    MS-Off Ver
    Excel 2007
    Posts
    24

    Change input text into upcase using macro

    Hi,

    This might be a silly question from me. If possible plz help me.

    I want to display any input text in capital letter in first row along with another word. I used the below code but I am getting error


    HTML Code: 
    If I enter company name as Oracle, then output should be --> ORACLE corporation

    Advance thanks for your help

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Change input text into upcase using macro

    sarat41.dash,

    Change upper to UCase
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Contributor
    Join Date
    12-31-2012
    Location
    Jhang, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    250

    Re: Change input text into upcase using macro

    Please Login or Register  to view this content.

  4. #4
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: Change input text into upcase using macro

    Your close

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  5. #5
    Registered User
    Join Date
    12-22-2012
    Location
    Basel
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Change input text into upcase using macro

    Thanks everybody!!

+ 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