Hi all. I have been trying to get a certain selection of cells to display inputs as capitalized no matter if entered in lower case. I looked through this forum and found some, I did try some of the suggestions, and I am having no luck. I am wondering what I am doing wrong? Any help would be greatly appreciated. Thanks in advance.
BigD1969,
Please read forum rules below before posting again. Your title has being amended.
See if link helps
http://www.ozgrid.com/VBA/force-case-text.htm
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
I have tried these and they don't seem to work. I have changed the value of the cells to the ones that I want, and when I enter lower case letters they stay that way.
If you want my help then please confirm you have read the forum rules and don't just ignore my request
VBA Noob
I have read the forum rules and I am looking for help in solving my problem.
Thank you. See if the attached helps.
VBA Noob
It works, yet after I copied the code over to my workbook, I have to go back to the cell that I inputted a letter then and only then does it convert to upper case. Yet in your example after I pressed return on my keyboard the converted right then and there. I am confused as how it is not working 100% for me.
The event macro runs when you change a cell in the range.
If the cells already have values then you would use a macro such as
Code goes in a normal module
Please Login or Register to view this content.
VBA Noob
Last edited by VBA Noob; 09-15-2008 at 05:13 PM.
I don't know what I am doing wrong. I am following the code you are giving me and still no success. Maybe this will help out. The column's I am trying to get to be uppercase are D & F. Column E has cell's with formulas in it. I don't know. Like I said in your example everything works fine. In my worksheet not so good.
It won't change formula's
Also you have to change the range to your ranges. Post a sample file if you want
VBA Noob
Here is the worksheet I am working on.
Not everyone has xl07 so best to save as xl2000
Try
VBA NoobPlease Login or Register to view this content.
Thanks for the help.
It works now. Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks