Excel ListBox

[koreggan]

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.

[Pecoflyer]

Perhaps this will help http://www.contextures.com/xlDataVal02.html