Sorry Posted to the wrong thread before I was even complete the answer.
Please disregard...
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

> Give this a whirl... The perserve key word keeps the values that may already
> be in the array. Without it any values in the array would be lost. Not
> neseccary in this case...
>
> Sub test()
> Dim ary() As Integer
>
> ReDim Preserve ary(10, 10)
>
> ary(0, 0) = 1
> ary(0, 1) = 2
>
> End Sub
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Jennifer" wrote:
>
> > Hi,
> > Listbox in a form that is filled by a combobox example:
> > User chooses "Oranges" from the cbobox and the listbox is filled
> > Invoice Number
> > 2
> > 5
> > 7
> > 8
> > 27
> > Lets say the user then multi selects invoice#5,7,28 I would like to hit the
> > enter button and it go back to the back database worksheet that all of this
> > is being pulled from SEARCH column "b" for those invoice numbers and then
> > place a "paid" in column "d" for the matching invoice numbers Example
> > Worksheet "ProduceData" Range "Database"
> > B C D
> > Invoices
> > 1
> > 2
> > 3
> > 4
> > 5 Paid
> > 6
> > 7 Paid
> > 8
> > . . .
> > . . .
> > 28 Paid
> >
> > Any help please! I am so lost on figuring this out. Thank you.
> > --
> > Though daily learning, I LOVE EXCEL!
> > Jennifer