+ Reply to Thread
Results 1 to 5 of 5

Automatic Uppercase

  1. #1
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Automatic Uppercase

    I have been trying to get this code to work and cant. It worked once and wont work anymore. What am I doing wrong??? I just want to have excel automaticaly change everything put in a cell to all capital letters. Thanks for help.


    HTML Code: 

  2. #2
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Canada Eh
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Automatic Uppercase

    Hi, the following may or may not help:
    Please Login or Register  to view this content.
    Last edited by Mad-Mizer; 03-18-2014 at 03:59 PM.
    Click the * to give Rep to a post you like.

  3. #3
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Automatic Uppercase

    Did .enableevents get set to false?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Automatic Uppercase

    Are you in the same worksheet as the one containing the code?

  5. #5
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Re: Automatic Uppercase

    In the Immediate box at the bottom of the VBA section I have:

    HTML Code: 
    It is in the same worksheet. I right cliqed on the tab to get there to make sure

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. uppercase
    By mubashar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2014, 08:17 AM
  2. Automatic conversion to uppercase
    By SgtSunshine in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-21-2010, 10:35 AM
  3. Automatic conversion to uppercase
    By SgtSunshine in forum Excel General
    Replies: 6
    Last Post: 05-19-2010, 02:23 PM
  4. Uppercase
    By Real Dummy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-21-2006, 08:50 PM
  5. Uppercase
    By Worzel Gummidge in forum Excel General
    Replies: 2
    Last Post: 01-16-2006, 12:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1