Auto filter list by form selection, VBA

Hi Everyone.

I’m new in using VBA in Excel, and this is my first "copy paste code". I want to use selections in forms to auto filter a list. I found this VBA code here, http://www.ozgrid.com/forum/showthread.php?t=91151 which does exactly what I need, but combined with forms, it doesn’t update.

I put my workbook here http://www.ferlev.dk/off/Sort_list_by_selection.xls

The cells I’m referring to are B29 & C29. Also I have no clue if the copied VBA code is okay. Is there a basic VBA guide somewhere in here?

Any help would be appreciated!

[I have theid to get an ansfer here (crosspost I guess) http://www.mrexcel.com/forum/showthr...88#post2003988 , without any replies ]

Andy,

Thx m8. You are a genius. I guess this isent the first time something like this have been made.

I am truley thankfull!

Andy,

I now realise I'm missing the option to disable/show all my list items ex. when selecting an input field called "Show all" or something similar. How is this done?

Any help are appreciated

Andy,
Thank you so much for your prompt reply!
I tried the code, but when selecting “*” it gives me autofilter 40 on ODSize.
Wouldn’t I need another expression in the if sentence?

Please Login or Register  to view this content.

Andy,
Thx again. Works great. Now I will have to finish the inputs constraints needed for us.
You have been a great help! Thanks again!