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:
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:
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.
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."
Are you in the same worksheet as the one containing the code?
In the Immediate box at the bottom of the VBA section I have:
It is in the same worksheet. I right cliqed on the tab to get there to make sureHTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks