#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Perhaps this will help http://www.contextures.com/xlDataVal02.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
filter, list, listbox |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
DropDown ListBox does not Drop Down | mmaule | Word VBA | 1 | 08-02-2015 05:40 PM |
This is a Userform LIstbox queston: A variable does not set to the value of a listbox | CatMan | Excel Programming | 14 | 08-18-2014 08:14 PM |
This is a Userform LIstbox queston: A variable does not set to the value of a listbox | CatMan | Excel | 1 | 08-08-2014 09:41 AM |
Data from Excel to Listbox multiselect to Word | marksm33 | Word VBA | 2 | 02-18-2014 08:30 AM |
Multi-select listbox help | gvibe@hotmail.com | Word VBA | 1 | 07-19-2013 10:54 AM |