I have a ListBox on a Uerform code is:

With Me.ListBox1
..RowSource = "A20:G50"
..ColumnCount = 5
End With

This works fine but it is not very neat for what I need. I need to start by
showing A20:G20 in the ListBox and then adding a row of data once the data
exists. How can I do this?

Also is it possible to format the indivdual columns in a ListBox, right
justify, center, font etc. Perhaps a ListBox is not even the right thing to
use?

TIA

Matthew