Userform text colour

[Damo10]

Hi,

I have a userform that has several textboxes on it that have several lines of data in each, is it possible to change the font colour of an individual item in a textbox without changing all the items in it?

Regards

 

[RoryA]

No, it isn't, I'm afraid. (not with a regular MSForms textbox anyway)

 

[Damo10]

Thanks for your reply, thats what I thought

Regards

 

[Jaafar Tribak]

Never occured to me to change individual colors of text in form controls. I expected to find something similar to TextFrame.Characters like in the Shape Object.

Anyhow if this was a label on a form, I would create a picture file containing the multi-colored text and then load the picture file on the Label via its Picture Property. Alternatively, I would use some APIs to render the text over the Label.

 

[pcc]

you could use several textboxes, and split the text up according to the required font colour. If you ser the textbox.specialeffect to ) (flat), and buttt them up against each other, to the user that looks like a single text box with different fonts. Will work for fixed text, but may not be ideal if the textboxes have variable text in them...

 

[Damo10]

Hi PCC,

I have changed them to listboxes ans now populate them using .additem and they all contain the same ammount or data but how much data does vary depending on what slection the user chooses, I would have liked to have changed the font colour for selections that have been completed but i dont think that this is possible.

Regards

 

[mikerickson]

Perhaps this will help
http://www.vbaexpress.com/forum/showthread.php?t=35563&highlight=listbox+highlight

 

[Jaafar Tribak]

This I guess can only be achieved by using graphical API functions to render colored text but i am not sure about the quality of the output.

 

[mikerickson]

Jaafar, the link goes to a workbook that uses labels over listboxes to hightlight particular list items, no API.

 

[Damo10]

Hi mikerickson,

can the text colour of an item be changed when it is being added to the listbox if it meets certain criteria?

Regards