A Listview has more formatting options and also has mousewheel scroll.
Slight drawback is that adding items is bit more complicated.

RBS

"Matthew" wrote in message
...
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