Compile error: Argument not optional

Hi,

While searching for possible answer to my questions using vba, i encountered a code that really fits my needs, the problem is i can't get it to work. the posts were somehow dead because it was posted last 2010. I tried to copy it create a userform but i encountered an error which wasn't a problem by the user who posted it. Can someone help me in debugging this code:

Please Login or Register  to view this content.

I highlighted the text whenever i received an error. I have 2 textbox (for filtering) and 1 listbox(result of the data) in this userform.

Thanks!

Hi AKK9,
Thanks for the reply and explaining it. Got it worked!!!