Listbox Properties

[Hap]

Is is possible to have different font properties in different columns of a listbox? If so how do I go about modifying these properties of an OLEObject added listbox?

Thank you

 

[mikerickson]

No, it is not.

 

[Hap]

That wasn't the answer I was hoping for but I appreciate the response. I am trying to display data on a worksheet that can be sorted sections with varying numbers of columns. Due to the varying length of data I wanted to dynamically add sections using listboxes purely as an information display tool.

Any ideas on another approach to this problem?

Thank you

 

[Hap]

Any new ideas here would be greatly appreciated

 

[mikerickson]

Instead of massaging a ListBox, you could hide/unhide columns and rows on a worksheet.

 

[Hap]

I'm creating a worksheet of selectable printouts. Each page on the worksheet has its own formating and I don't want to be tied to the gridlines of the rows and columns for data placement. Also I am wrapping data to multiple printout pages based on total length. Each listbox contains a section of data that will be added to a given page if there is print space on that page.

Thank you