Change Font color in UserForm Textbox for new text and retain to copy to cell on worksheet

[DThib]

Hello all,

This may be simple or impossible, I do not know.
I have a Userform textbox that copies data from a table. The box can have data added before it is copied back to the cell. If that happens I would like the data created in the UserForm to turn red and leave the original text
untouched.
Is there a code to do this?

DThib

 

[DThib]

Help!

 

[DThib]

I am guessing there is no answer to this.
The highlighted line would be added after the project is accepted. The user enters today's date and the information. Another button replaces what is in the cell it was drawn from and I need the highlighted line to be red, the rest of the text black.

Anyone?

DThib

 

[GWteB]

Changing a TextBox's Font, ForeColor or BackColor property affects the entire text within that TextBox.
It's not possible to provide parts of text with a different color.