After a bit of thinking and groping about I managed to get column head
to work by putting th following into :-
Private Sub UserForm_Initialize()

ListBox1.ColumnHeads = True 'show headings
ListBox1.RowSource = "B2:D2" 'point at column headers
offset?

I had three colunm's so "B2:D2" gives three headings, although I di
notice to get the right result I had to point to data at row 2 and no
row where the data was?

Hope this helps any one else trying to get this working.

Noggin

PS still like to know why the offset though

--
Message posted from http://www.ExcelForum.com