Thread: Find
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jennifer Jennifer is offline
external usenet poster
 
Posts: 385
Default 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