Floating textbox in excel

Question

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:

http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/how-to-create-a-floating-text-box-in-excel/59c7533c-c5b3-4096-bef2-4e9bac2176bf?auth=1

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?

Edit

It was suggested to use an activeX textbox and I tried that, but I don't know which property I should change.

Answer 1

To change the color of the text in a userform, use this line:

userFormName.TextBox1.ForeColor = &H00AABBCC&

Where userFormName is the name of the form, and TextBox1 is the name of the object you want to change color of.

The first 2 zero's in the &H value are used to flag whether the colour is a system colour, like button face or windows background.
AABBCC is like a normal hex RGB code, but backwards.
AA is blue, BB is Green and CC is the value for red.
So &H000000FF& would be red.