VBA macro UPPER auto case

I am new to VBA macros and the one I made is not working.

Found this with Google.

Please Login or Register  to view this content.

I created the macro and saved as Macro Enabled Workbook. I want certain cells to auto capitalize when I enter the data.

This is how I would like it done:
-B3 Capitalizes first letter of first and last name if possible. If not then all caps.
-B5 All caps
-B7, 8, 9 all caps
-B12, 13 all caps

Could use help on this.

Thank you.Stock orderTemplate2.xlsm

Please Login or Register  to view this content.

Regards, TMS

1) Right click on the Sheet1 tab and select View Code
2) Paste this self-triggering event into the sheet module that appears:

Please Login or Register  to view this content.

3) Close the VBEditor and save your workbook

Review the macro til it's clear what is happening at each step. Then try putting some values in your sheet1.

I guess this:

Please Login or Register  to view this content.

should be this:

Please Login or Register  to view this content.

Yes, yes! Thanks, corrected above. (hat-tip)

Extend the case lists to include the other ranges.

Let's do it this way, assuming you're going to copy the EXACT same codes from column A to all the other sections, we can make it dynamic, in this way it will look to the left of the cells you change to see what the text is. If the text is "Client" it will make your entry ProperCase. If it's "Account Type" or "Buy/Sell" etc... it will make your entry UPPERCASE.

Another benefit is this means you can rearrange the order of the rows and it will still work!

Please Login or Register  to view this content.

Yes, remove your old macro completely, put this new one into the Sheet1 code module so it will activate itself as you type.

You need to remove the macro completely temporarily while you finish setting up your sheet. Once you have all the sections setup and ready to use, put the macro from post #9 back into that sheet module and give it a spin.

Thanks for the rep.

Well, this question was answered and the thread marked solved. So, following up with a new question is not such a good idea. If you start a new thread, it will have a zero reply count and more people will take an interest. You can provide a link back to this thread:

http://www.excelforum.com/excel-programming-vba-macros/1049142-vba-macro-upper-auto-case.html

So, more interest and maintain the history.

I don't answer questions in the Commercial Services sub-forum. JB does.


Regards, TMS

I agree with TMS in regards to new threads garnering new eyes and possibly faster response as such. However if your followup question is really about this exact same topic, then continuing here would be fine and perhaps prudent.

But resist the idea that any question regarding your workbook/project are all the same topic, they're not, and may truly belong in new threads, either in the free or CS forums. You could be pursuing several different discussions in several threads on issues that relate to the same workbook, but are not the same issue.



Usually marking a thread SOLVED indicates your original topic was truly resolved, and most likely your new issues or need is because of something that is actually new, this a new thread is almost always the way to go in that regard.