Dynamic/Dependent lisbox.

[D_Rennie]

Howdy All.

I would like To display product information in a multi column listbox. Column 1 is a product category and Column 2 is the product description.

Now for the dynamic part.
I would like to have a combobox loaded with non duplicated values of column 1 of the listbox.
When "~Caulking~" is selected from the combobox. The listbox is to display only the "~Caulking~"products and their description.
And having a value of "~All Items~" placed into the combobox will display All products in the listbox.

The sheet that will contain the raw data source can/will have items added to inceacing the row count. Also the sheet will be left in an unknown sort by column state.

I thought of taking the raw data source and copying it to a new sheet and splitting the data into various columns, Eg 1 column for "~Caulking~" another for "~All Items~"... and then removing the sheet on userfrom completion. Or possably using collections or scripting dictonary or anythink that works well.

Any Advice will help alot.

Cheers

[rwgrietveld]

Surf here and you'll get a very good step by step tutorial:
http://contextures.com/xlDataVal02.html

[D_Rennie]

Thankyou.

My fault for not putting up enough information.

I would like to do this from a Userform. i have probley missed out more info like.
this will eventually end up in a multipage userform. Will have to be able to copy a selected row and use listbox column 2 as the selected output. Possibly allow for drag and drop behaviour.

cheers again.

[D_Rennie]

There is one way i know this can be done.

Please Login or Register  to view this content.

I have code for populating the combobox with only unique entrys somewhere aswell.
Ill just go with this.

though if there are other ways of doing this i would like to look into it.

cheers