View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default 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