Printable View
I'm using the ListBox component on excel to basically dump a bunch of text lines into a scrollable area. What I would like is a similar component that would allow me to change the colors/fonts of the indivdual items in the list.
Can anyone direct me to such a component?
Thanks for the help.
heybeerman:
I don't think there is such a component.
If Excel had a listview control like in VB6 then it might work, but there is no such control in Excel. You might find a comercial control you could purchase or maybe even a shareware control if you are lucky.
Your posting is a little bit contradictory in that you first say you "dump a bunch of text lines" and then you say "individual items in the list" ?? Do you have a "bunch of tect lines" like sentences or do you have "individual items" like products such as soup, juice, cereal, etc., etc., each appearing on lne line?
How many are in a "bunch"?
If your "bunch" is only 5 or 10 items then you might do a work-a-round by putting several text boxes in a column, lined up so they touch each other, without any borders. This would make them appear as a list box, but you could use the Font property and Forecolor property of each text box to change the Font and Color in each text box.
This would require a little extra coding and probably wouldn't work if your "bunch" is 25 to 50 items.
Not sure this helps??
Perhaps someone else will have a better solution for you.
Good Luck
sorry about the vagueness.Quote:
Originally Posted by AIS4U
When I say bunch, I mean a few hundred entries. It's an event log and I want to be able to color code individual lines.
heybeerman:
Well, in that case, I guess my work-a-round wouldn't work.
Hopefully some Excel Guru will be able to provide you with a solution if there is one.
Thanks for taking a look.Quote:
Originally Posted by AIS4U