Thanks Leith, Bob & Tom,
I've got it now, the 'penny has dropped'
I couldn't see the steps: first add a row, then populate it. I was trying to
populate as part of the AddItem method
Much appreciated
--
David

"Leith Ross" wrote:


Hello David,

The AddItem method inserts a single Row into the ListBox. The
ColumnCount property sets the number of Columns. You cna then set the
individual columns using the Column property. The code example shows
how to add the data without creating an Array. You can use the Column
property in your code to get or set a Column Value in a given row.
Remember Line, Column, and Row numbers start at zero.

COLUMN PROPERTY FORMAT:
Column(<-column number-, <-row number-)


CODE EXAMPLE:
With ListBox1
.ColumnCount = 2
.AddItem
.Column(0, 0) = "Cat"
.Column(1, 0) = "Dog"
End With


CHANGE A COLUMN VALUE:
ListBox1.Column(1, 0) = "Rat"



Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=479250