View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tkt_tang@hotmail.com is offline
external usenet poster
 
Posts: 92
Default Re : Excel AutoFilter being Toggled of VisibleDropDown

Re : Excel AutoFilter being Toggled of VisibleDropDown

1. Enter an Excel worksheet and VBA thereof.

2. In the midst of,
ActiveSheet.AutoFilter.Filter(1)
being toggled by,
VisibleDropDown:= False and
VisibleDropDown:= True,
How could VBA code be deployed to test the States of VisibleDropDown
thereof ?

3. Please share your experience (of tracking the States of
VisibleDropDown of an AutoFilter and several others via VBA).

4. Regards.