VBA: Script that changes new text to another color

Hi,

Try this code

Please Login or Register  to view this content.

I hope this helps

Thanks you very much. I have another question, how can we make it that only works for this matrix cell A9-L300? Also, options like select all, select column or row, undo, etc are not working. Any ideas?

Hi again,

The changes to the Worksheet_Change subroutine will restrict the range, and the changes to the Worksheet_SelectionChange subroutine will allow you to select rows, columns, and all.

Please Login or Register  to view this content.

As for the Undo function, one unfortunate side-effect of VBA is that you cannot undo a change made in VBA with the regular Undo function.

I hope this helps

It worked perfectly. I will proceed to create a macro function that will back up the information in a temporary manner to compensate the UNDO loss. Thank you so much once again.

No problems!

Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks

Hello again, sometimes I need to color something manually but the code doesn't allow me to it unless I delete the code from the module. Any ideas?