+ Reply to Thread
Results 1 to 10 of 10

Auto convert lower case to Upper in same cell

  1. 08-07-2014, 11:01 PM #1
    russkris
    russkris is offline
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Auto convert lower case to Upper in same cell

    Hi all,

    Stupid question for most but I just can not find anything.

    I have create a few lists in Column B, C, D

    What I would like to do is if a person enters lower case rather than using the drop downs, excel will convert it to upper case.

    Why... Because I am a neat freak..lol

    If it can not be done, then so be it.

    I uploaded a .xlsb file as the xls file was something like 5mb, dunno why, it doesn't have anything in it. The full size version is 13mb and it's got a bit of formatting.

    Anyway. Many thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-07-2014, 11:12 PM #2
    mongoose36
    mongoose36 is offline
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: Auto convert lower case to Upper in same cell

    Place this code in the Worksheet Module of the Worksheet you want this done on.

    Please Login or Register  to view this content.
    If your questions has been answered to your satisfaction please don't forget to do the following:

    Add Reputation ... and ... Mark Thread as Solved

    Thanks,

    Ma 10:8b Freely you have received; freely give.
    Reply With QuoteRegister To Reply
  3. 08-07-2014, 11:19 PM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Auto convert lower case to Upper in same cell

    Right click on your Sheet Tab --> View Code --> Paste the code given below in the opened code window --> Close VBA editor --> Save your workbook as Excel Macro-Enabled Workbook.
    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  4. 08-07-2014, 11:21 PM #4
    russkris
    russkris is offline
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Auto convert lower case to Upper in same cell

    Wicked. Thanks heaps.

    However, I added it, typed a lower case letter and excel stopped working.

    Saved the file as macro enabled, still the same.

    EDIT: I will try yours sktneer
    Reply With QuoteRegister To Reply
  5. 08-07-2014, 11:23 PM #5
    russkris
    russkris is offline
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Auto convert lower case to Upper in same cell

    Nope same thing
    Reply With QuoteRegister To Reply
  6. 08-07-2014, 11:47 PM #6
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Auto convert lower case to Upper in same cell

    One cause may be your named ranges are referencing to another sheet. Try placing your named ranges on the same sheet and see if this helps.
    Reply With QuoteRegister To Reply
  7. 08-08-2014, 01:17 AM #7
    russkris
    russkris is offline
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Auto convert lower case to Upper in same cell

    ok will try that.

    I tried to upload a sample to see if it did it on your computer.

    Will report back.

    Cheers
    Reply With QuoteRegister To Reply
  8. 08-08-2014, 01:24 AM #8
    russkris
    russkris is offline
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Auto convert lower case to Upper in same cell

    Sadly. No.
    Reply With QuoteRegister To Reply
  9. 08-08-2014, 01:54 AM #9
    mongoose36
    mongoose36 is offline
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: Auto convert lower case to Upper in same cell 

    Please Login or Register  to view this content.
    When the code changed the case it fired the worksheet change again.
    Reply With QuoteRegister To Reply
  10. 08-08-2014, 02:01 AM #10
    russkris
    russkris is offline
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Auto convert lower case to Upper in same cell

    Run-time error '438':
    Object doesn't support this property or method

    Debug
    Application.EnabelEvents = False
    Reply With QuoteRegister To Reply
  11. 08-08-2014, 02:50 AM #11
    satputenandkumar0
    satputenandkumar0 is offline
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Auto convert lower case to Upper in same cell

    try bleow,

    Please Login or Register  to view this content.
    Regards,
    Nandkumar S.
    ---------------------------------------------------------------
    Don't forget to Click on * if you like my solution.
    Reply With QuoteRegister To Reply
  12. 08-08-2014, 06:49 AM #12
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Auto convert lower case to Upper in same cell

    cplettner is correct. See the attached sheet, the code is working fine.
    Attached Files Attached Files
    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. [SOLVED] Help needed with a formula to convert upper-case words only to lower-case
    By holmwood in forum Excel General
    Replies: 7
    Last Post: 04-18-2014, 04:11 PM
  2. [SOLVED] Lower Case to Upper Case but No Auto Correction : Solved by Mod (6StringJazzer)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2014, 10:44 AM
  3. [SOLVED] Convert 1st letter of word to Upper Case and rest to lower case
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-23-2013, 11:44 AM
  4. [SOLVED] Convert lower case charecters to upper case
    By Dinesh in forum Excel General
    Replies: 3
    Last Post: 09-10-2005, 08:05 AM
  5. How do I convert all upper case excel sheet into upper and lower .
    By DebDay in forum Excel General
    Replies: 1
    Last Post: 03-09-2005, 05:06 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