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