In your ListBox, set the ColumnCount property to 3, ColumnHeads
to True, and RowSource to the range of cells *below* the text
that serves as column headers. The cells above the RowSource
range will be used as column headers.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Todd Huttenstine" wrote
in message
oups.com...
Hey guys

I have a userform with a listbox (ListBox1) on it. I want to
show 3
column headers on the listbox called:

Market ID Market Cd Mkt Name


How do I do this?


Thank you
Todd Huttenstine