I am using excel 2010. I have a textbox with a multi-color message in it.
I would like for it to stay in place when I scroll through my worksheet.
I've searched google for it and came up with this solution:
It uses userforms and textboxes from VBA. My question now is: how can I give the text that is displayed in the textbox a certain color (so that it matches the text box I already have)? And if this is not possible, how can I 'lock' the text box I have to keep it visible at all times?
It was suggested to use an activeX textbox and I tried that, but I don't know which property I should change.