VBA - auto uppercase does not allow multi color text

[adamheon]

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.

[6StringJazzer]

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.

[adamheon]

Thanks for the reply.

What I would want is the last letter to be white in specific cells.

This would not apply to every cell but in certain cells that i choose. Thanks for the help!

[daffodil11]

What is the criteria for the cells that have the last letter changed?

Perhaps using an IF to check if the contents are in UCase format to prevent iteration.

This way if you do change the contents after the fact, the Worksheet_Change doesn't kick off again on that cell and instantly reapply default formatting.

[6StringJazzer]

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.

[adamheon]

Great thanks. could you show me an example of an IF statement that would specify a cell? (i'm still new to code and IF formulas)

[Izandol]

You may change the text without changing the format:

Please Login or Register  to view this content.

[adamheon]

Thank you. Works great. I have another issue but i will start a new thread.