Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
AutoFilters | Excel Worksheet Functions | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
How to set up AutoFilters? | Excel Worksheet Functions | |||
autofilters | Excel Worksheet Functions |