How to get early filter?

A

anvarfromkz

Hello, Dear Professional Programmer

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

I found this but it is not what i need :

lngCount =
For Each objFilterPart In ActiveSheet.AutoFilter.Filter
If objFilterPart.On The
strFilterList = strFilterList &
"Columns " &amp
ActiveSheet.AutoFilter.Range.Columns(lngCount).Column & vbC
End I
lngCount = lngCount +
Next 'objFilterPar
MsgBox strFilterLis

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top