View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bruccce Bruccce is offline
external usenet poster
 
Posts: 20
Default Help with Userforms and filters or autofilters

I have been fighting this for about a year now and I have no idea what I am
doing!
Apparently Userforms do not recognize filters or autofilters set at the
worksheet.
I have created a macro of a autofilter and tried to run this in the
userform, but again, this did not work...
I have had someone implement a filter for me and it works OK, but I get
totally lost in following the code. I need to make changes or start from the
ground up (prefer starting from the ground up actually at this point!)

Where can I find info on how to set up filters/autofilters when I am using a
userform? I am green to VB so commented code sample would be a BIG plus...

How about an example or two? One thing would be that I would want to filter
on TimeZone (columnG) these values range from 0-3 typically
what would the code be to see only timezones with a value of 1 if I were to
use a clickbutton?

What would be the code if I was to use 2 textboxes and a clickbutton to
activate. The textboxes would hold them min and max values

And how about a button that releases all filters?

There are more things, but with some samples, I hopefully would be able to
create the more complex filters.


Is this REALLY as difficult as I am making it?

Thanks
Getting desperate
Bruce