Using Combobox Selection to Filter Data

[justdave3283]

Hi all.

Once again, any help on this will be greatly appreciated.

In my spreadsheet, I've created a combobox with two dependent listboxes and a command button ("Show")

What I need is for the data in the sheet to be filtered to show only the data which matches the selection in the second listbox.

Listbox one contains all available options in Column D. listbox two contains all available options in Column E, depending on first selection.

I'm doing this to try and make it easier for colleagues with a fear of computers to be able to get the info they need without having to manually filter the data.

Please help.


Regards

Dave

 

[Worf]

Hi
see if this is useful:

' paste this at the sheet module
' filters column E by value of list box 2


Private Sub CommandButton1_Click()
    
    Me.Range("e:e").AutoFilter 1, Me.ListBox2.Value


End Sub