ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help with Userforms and filters or autofilters (https://www.excelbanter.com/excel-programming/273208-help-userforms-filters-autofilters.html)

Bruccce

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




All times are GMT +1. The time now is 09:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com