Filling a List Box in Excel from an Array
As an example
For i = LBound(ary) To UBound(ary)
Listbox1.AddItem ary(i)
Next i
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Martin" wrote in message
...
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
|