Can't Filter Sheet from inside a UserForm

[Guest]

I created a form with an Option List.
I would like to click on the option and have the worksheet filtered by the
option I select on the form.

I'd like to do this in real time without closing the Userform and see the
filter in real time, then be able to click another option and see the new
filter updated.

Any Ideas?

I think I have been able to get some functions like this to work but not
unless I close the user form first.

 

[anonymousA]

Hi,

If the screenupdating instruction is not on, you'll see things change in
your sheet.
Anyway, why don't you open your userform on the modeless mode? I guess It'll
fix the problem.

show userform 0 (zero not O)
or show userform vbmodeless

So long