Thread: [Solved] Excel ListBox
View Single Post
 
Old 04-23-2016, 05:32 PM
koreggan koreggan is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Apr 2016
Posts: 1
koreggan is on a distinguished road
Question Excel ListBox

Hello there,

I'm working in a project where I need to use two list boxes to fill a form with selected data. It goes something like this:

I have a db with Company, Product and the product's specifications. So, for example, I have:

Company 1 - Product 1 - Specifications 1
Company 1 - Product 2 - Specifications 2
...
Company 2 - Product 1 - Specifications 1

And it goes on like this.

What I need is to create a list box containing the companies and a second list box containing the products. The real magic is, when I select the company in the first list box the second one is filtered to only products of the selected company and only then I select the product that I want and it fills the form.

Can someone help me with this task?

Cheers.
Reply With Quote