Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table filters, especially DATE filters chris Excel Worksheet Functions 0 August 27th 08 04:33 AM
AutoFilters Joli Excel Worksheet Functions 1 March 21st 06 09:14 PM
Filters, Subtotal & Intacted Results after the filters' Removal kasiopi Excel Discussion (Misc queries) 5 February 24th 06 12:18 PM
How to set up AutoFilters? MS Suzanne Excel Worksheet Functions 1 June 30th 05 03:53 AM
autofilters Diego Villaseñor Fernández Excel Worksheet Functions 0 January 13th 05 11:27 PM


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"