ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to get early filter? (https://www.excelbanter.com/excel-programming/443078-how-get-early-filter.html)

anvarfromkz

How to get early filter?
 
Hello, Dear Professional Programmers

I have question how to get what was field filtered. I created Form like Custom
filter, you know that when i open the Dialog it shows criteria filtered early.
For example "Equal" = "5"
or "Have" = "Ans"

I found this but it is not what i need :(

lngCount = 1
For Each objFilterPart In ActiveSheet.AutoFilter.Filters
If objFilterPart.On Then
strFilterList = strFilterList & _
"Columns " &
ActiveSheet.AutoFilter.Range.Columns(lngCount).Col umn & vbCr
End If
lngCount = lngCount + 1
Next 'objFilterPart
MsgBox strFilterList

Thank you for answer about Filter Javed, Jef Gorbach early.


All times are GMT +1. The time now is 10:15 AM.

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