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.
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
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.
How to Paste a Macro into a Worksheet
Please Login or Register to view this content.
- Copy the macro with Ctrl+C.
- Right Click the Sheet Tab at the bottom of the worksheet.
- Click View Code
- Paste the macro into the module with Ctrl+V.
- Save the macro using Ctrl+S
Sincerely,
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 Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Works like a charm! A big "thankyouverymuch"!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks