+ Reply to Thread
Results 1 to 4 of 4

Uppercase and Proper in one and the same worksheet

  1. #1
    Registered User
    Join Date

    Uppercase and Proper in one and the same worksheet

    Hi, I messed around with some code I found on the site but I'm not able to put togheter two "Worksheet_Change" macros. Probably needless to say but I'm new to VBA.

    I have one cell that has to be forced into uppercase (B9) because it's a last name and another cell on the same sheet that has to be forced into proper because it's a given name.
    I found code for forcing one kind of case (upper, proper or lower) but I cannot make it work to do what I need, two kinds of cases.

    Thanks for any help.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010

    Re: Uppercase and Proper in one and the same worksheet

    Hi Petruscafe,

    Welcome to the Forum!

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010

    Re: Uppercase and Proper in one and the same worksheet

    Hello petruscafe,

    Welcome to the Forum!

    Just to be clear, each worksheet has it's own Worksheet_Change event procedure. You can not combine these procedures because they exist separately.

    That being said, you probably are dealing with two cells on the same worksheet and what to automatically change the case of each cell. The code below will do that. Please be sure to change the cells to match the ones on your worksheet.

    Please Login or Register  to view this content.
    How to Paste a Macro into a Worksheet
    1. Copy the macro with Ctrl+C.
    2. Right Click the Sheet Tab at the bottom of the worksheet.
    3. Click View Code
    4. Paste the macro into the module with Ctrl+V.
    5. Save the macro using Ctrl+S
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  4. #4
    Registered User
    Join Date

    Re: Uppercase and Proper in one and the same worksheet

    Works like a charm! A big "thankyouverymuch"!

+ 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. [SOLVED] Convert first letter of every word to Uppercase . Not Proper casing
    By rampulaparthi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-27-2013, 04:46 AM
  2. [SOLVED] How do I reformat my database from all uppercase to proper?
    By Princey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2006, 04:59 PM
  3. [SOLVED] Use "PROPER" to change UPPERCASE text to Title Case on worksheet
    By cmurdock in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-31-2006, 07:20 PM
  4. How do I change uppercase to proper case in entire worksheet?
    By Karen in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-21-2005, 08:05 AM
    By mineralgirl in forum Excel General
    Replies: 4
    Last Post: 09-02-2005, 09:05 PM

Tags for this Thread


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