View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
anvarfromkz anvarfromkz is offline
external usenet poster
 
Posts: 2
Default 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.