List Box

[heybeerman]

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.

[AIS4U]

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

[heybeerman]

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.

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.

[AIS4U]

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.

[heybeerman]

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.