![]() |
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