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

On Sep 5, 8:37*am, ranswrt wrote:
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-prog...lumnheads.html

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

"Greg Glynn" wrote:

On Sep 5, 8:37 am, ranswrt wrote:
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-prog...lumnheads.html