ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple Instances of Same Listbox (https://www.excelbanter.com/excel-programming/370163-multiple-instances-same-listbox.html)

[email protected]

Multiple Instances of Same Listbox
 
Hi,
I'm working to build a grid that will list a group of customers down a
column, and then, across a row, list several products, and then below
each product, a variety of formatted cells for different quantities to
be entered for each of the customers.

Here's the quandry.

The products are being imported from a different spreadsheet generated
from a seperate database. I need to validate each of the product names
with the names I'm getting from my database via MS Query.

My plan is to display a listbox above each of the displayed product
names, allowing the user to pick the most appropriate name from my
database.

For n products imported from the other spreadsheet, how can I display n
listboxes, each with their own, unique linkedcell?

Any assistance is appreciated.

Thanks
Joe



All times are GMT +1. The time now is 10:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com