http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data


What you mean by filter is not very clear. Are you trying to filter
information shown in a listbox on the form or use the form to get setttings
for an autofilter (as an example) on a worksheet?

Regards,
Tom Ogilvy



"Bruccce" wrote in message
news:uJRXa.72449$YN5.55027@sccrnsc01...
I am trying to create a userform that I can set filters in. I am looking
for
how to do this.

I have tried creating a macro that sets the filter I want, and put it in
the
userform, and assigned this to a button, but userform does not seem to
recognize the filter. It still shows every record. What am I doing wrong

Where can I find this info? (I have several books, but I can not find this
combination covered....)

I have had somebody create a userform for me, but I need to change the
filter, and I need to change a lot of other items about the form, so I
want
to basically start from scratch.

I would like to LEARN how to do this so I can maintain my own code.

thanks
Bruce