ACTIVE X ListBox - set column color

[raf]

Hello Team,

I there a way I can assign colors to the columns of my ActiveX Listbox?
for example, I want column 1, 2, 3, 4 to show Black, and 5, 6, to show orange.

Thank you

 

[Chihiro]

AFAIK - You can only set background colour for entire listbox.

Alternate method is to register MSCOMCTL.OCX and use ListView control.
Office must be 32-bit version for this to work though.

See link for how to change color for ListView control.
http://www.mrexcel.com/forum/excel-questions/410375-change-color-format-listview.html