VBA - auto uppercase does not allow multi color text

i'm using the following code to make all text uppercase. However i also want to be able to have different color text in 1 cell.

For instance i may 'A B C' in cell A1. I when i try to make A red i turns back to black. can i change this?

Please Login or Register  to view this content.

Formatting of individual characters within a cell are tied to the character. That is, if you have

abc

and uppercase it, you are changing the characters and therefore the formatting for the new contents reverts to the default.

ABC

The way to do what you want is to add code to create the formatting you want. Will you always have the same formatting in each cell? That is, is the first character always red? Or is it different from cell to cell? If it's always the same you can write code to do that. If it's different, you have to write code to determine what formatting is used, then change the text, then re-apply that formatting.

I can help with this but would prefer to get all the details before I start giving you code.

This modifies your existing code to change the last character to white font. You need to add an If statement that specifies the certain cells you choose.

Please Login or Register  to view this content.