List boxes

[Lionel Fridjhon]

I have a list box named lstRecipes with 11 columns.
The lstRecipes.Value contains only the contents of the
first column.
How can I get the whole array of ll columns of the
selected row, and paste them into a row in a spreadsheet?

Lionel

 

[Bob Phillips]

Hi Lionel,

You can access them through the List property. For example,

With ListBox1
MsgBox .List(1, 0)
MsgBox .List(1, 1)
End With

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)