Hi Everyone,

Seeking a bit of help on an issue....I'm running into a tight deadline
on a project and am stuck on how to code an array for a listbox.

Here's the issue. I have Listbox1 which contains several rows and
columns of data. When selected it distributes the values of each
column of row to several textboxes. Once the row has been selected
and the value placed in the textboxes, a lookup must be completed that
would extract from Listbox1 (or its array) each row that contains that
value in the textbox. Each row containing that value will be placed in
Listbox2. I realize it requires an iteration of the array in Listbox1
with an if..then / for ...next code structure but I'm stuck ...whether
i've been looking at this thing for too long or its lack of
sleep...I'm clearly stuck.....any help would be greatly appreciated

here's my code for listbox1:

Set rg = objXL.worksheets(1).Range("A1:d17")
Call RangeToArray(rg, arr)
Set ListBox1 = Item.GetInspector.ModifiedFormPages("pg.
2").Controls("ListBox1")
ListBox1.List = arr
End Sub

Thanks...!!!