Find
 

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

Find
 

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