List Box

[dalinnus]

Thanks to Mr. Excel's book "VBA and Macros for Microsoft Excel" I have been able to: Create a form to browse to a file, import the file. Then using the advanced filter I can create a unique list based on one of my columns and create a list box based upon this unique list. The very LAST piece that I am stumped on is how do I now filter the data based upon the Items the user had selected in the list box?

HELP!

 

[Smitty]

Welcome to the Board!

You can record Filtering you range, then substitute the List Box's value for the criteria. I.E.

ActiveSheet.Range("$A$1:$B$8").AutoFilter Field:=1, Criteria1:=ListBox1.Value

Hope that helps,

Smitty

 

[dalinnus]

I am sorry I do not understand. I am using a multi-select list box and it is my understanding that you cannot use the autofilter with the items selected by the multi-select list box--What I need to do is filter the data in the worksheet, specifically the column that I used to created the list box with and use the items that the user selected in the multi-select list box for the filter.

If I were to use the code above, would I put it on my 'OK" button that the user clicks when he is finished selecting the items in the list box??

 

[Smitty]

You'd really need to post your code.

Smitty

 

[dalinnus]

How do I post my code??

 

[Smitty]

Just copy it from the VBE and post it in a new repy.

Then highlight it and click the Code button above the text entry.

Or just paste it in and I'll add the tags for you.

Smitty