Multiple Instances of Same Listbox

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Re: get text from listbox
    ... it is drug data and you would it recognize directy if you had found ... database entry displayed by the respective list entry. ... At least this is the way>I< would code such listbox... ... shouldn't be very difficult if you know the font properties used to display ...
    (microsoft.public.vb.winapi)
  • Re: get text from listbox
    ... if the numbers were database id numbers that would be fine as I know the database and have ... The database is Interbase and there only could be 2 tables involved for the bit of the listbox I am interested in. ... and selecting it into a device context the properties of which are the ...
    (microsoft.public.vb.winapi)
  • Re: Using ADO to populate a List Box
    ... you do not want to see by using the ColumnWidths attribute of the Listbox. ... Dim myDataBase As Database ... Doug Robbins - Word MVP ... > How would you code this if you only wanted tthe Listbox to display one ...
    (microsoft.public.word.vba.beginners)
  • Re: Q: Tip and advice on DataBase related question.
    ... In this case I prefer avoiding display all the data, ... I am going to build my firs Windows Application that involves a Database. ... One of the tables includes over a milion customers. ...
    (microsoft.public.dotnet.languages.csharp)
  • From ListBox to Excel to TextBox
    ... using VBA to organize my database, but I came up with a big problem. ... display it as a listbox. ... Now, I have in Excel, on the same row for each number on ListBox ...
    (microsoft.public.word.vba.beginners)