Results 1 to 2 of 2

Determine if VisibleDropdown is True for Field in AutoFilter

Threaded View

Xx7 Determine if VisibleDropdown... 05-09-2014, 04:29 PM
Leith Ross Re: Determine if... 05-09-2014, 05:10 PM
  1. #1
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Determine if VisibleDropdown is True for Field in AutoFilter

    I would like to determine if the VisibleDrowndown is TRUE in the attached table.

    The current macro sets it to FALSE in field 1. However, I want to identify when it is TRUE so I can run this macro.
    Sub tester()
    
    ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=1, visibledropdown:=False
    
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Hide VisibleDropDown in PivotTable ColumnFields
    By goss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2014, 03:05 PM
  2. Visibledropdown false not hiding all arrows
    By WasWodge in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2010, 07:15 PM
  3. Determine If A Cell Entry Is In A List And Return True
    By wulliemc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-14-2009, 05:16 AM
  4. using TRUE FALSE chk boxes to determine a cell value
    By meushi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2006, 06:20 AM
  5. Determine Value of Autofilter
    By Evan in forum Excel General
    Replies: 1
    Last Post: 06-01-2005, 08:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1