Limit Listbox and ComboBox Results

[Cuba64]

Hello,

I have a new problem, I would like to minimise the amount of results in my ListBoxes by using ComboBox selections.

See attached example.

I would like the ListBox on UserForm1 to show all reference number when no selection is made from the ComboBoxes... When they are left at default settings... Type and Opponent.

When Type is selected, either Fight or Special, the ListBox is limited to only show results of that type. ie. Special will only show reference numbers that refer to that Type... Barrels, Wall or Car and vice versa. Alternatively if Type is left alone and only an option from the Opponent ComboBox is selected the ListBox would only show references that refer to that Opponent. ie. Honda is selected, it will only show references relating to Honda and the same for all. If Fight was selected then the second ComboBox would only show the names minus Barrels, Wall and Car, and again vice versa.

When both ComboBoxes are used, say Fight and Ryu, it would limit the ListBox would only show references matching those.

I really don't know where to start with this, If anyone could help me out it would be much appreciated.

Regards,

Cuba

Example2.xlsm

[Solus Rankin]

You can try:

Please Login or Register  to view this content.

I wasn't able to test it. There was a glitch on my PC with your spreadsheet.

[Cuba64]

I'm getting errors...

[Solus Rankin]

What are the errors? What line?

[Cuba64]

It errors at "ListBox1.Clear"

[Cuba64]

Its a "run-time error '-2147467259 (80004005)'

[Solus Rankin]

How are you populating the listbox to begin with?

[Cuba64]

Using "Row Source" I think

[Cuba64]

Sorted it by removing the row source Thanks