Listbox Column help

[ranswrt]

I have two questions:
I am adding items to a multicolumn listbox using an array (listbox1.list() =
array). How do I add column heads when building a listbox this way?
and
How do I format each column for currency and horizontal alignment?

Thanks

 

[Greg Glynn]

I have two questions:
I am adding items to a multicolumn listbox using an array (listbox1.list() =
array).  How do I add column heads when building a listbox this way?
and
How do I format each column for currency and horizontal alignment?

Thanks

Beats me.

http://www.excelforum.com/excel-programming/533105-userform-listbox-columnheads.html

 

[ranswrt]

Is there a way to format the column for currency and the horizontal alignment?