Another example.

Dim strArray(2) As String

strArray(0) = "X"
strArray(1) = "Y"
strArray(2) = "Z"
ListBox1.List = strArray

Cheers
Andy

Martin wrote:
Hope someone can help. I have a listbox in excel which I am trying to
populate from an array. The array is picking up certain values from a sheet
depending on a previous value selected in another list box. I currently have
the array code in a module.

regards,
Martin

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info