Results 1 to 4 of 4

Filter table based on ActiveX Checkbox

Threaded View

  1. #1
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Filter table based on ActiveX Checkbox

    Hello all,

    I typically try to stay out of the realm of VBA due to my lack of knowledge regarding it, but for my current application I believe a little coding may save me a lot of future hassle.

    Attached you will find an example of what I am trying to accomplish. I have found bits and pieces of possible ways for this to work around the internet, but cannot post them here as per the forum rules (for what it's worth, I tried some of the suggestions but to no avail).

    Basically, I have a table on Sheet2 that I would like to be able to filter based on selected ActiveX check boxes on Sheet 1. However, the table on Sheet2 has some fields that are updated dynamically based on data validation from Sheet4, so I would hope that there is a solution that is flexible to account for that.

    I am willing to work with limited information to produce a first attempt of my own; I just need a push in the right direction is all.

    Hope I was clear, and thanks in advance for any help!
    Attached Files Attached Files
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-27-2014, 10:57 AM
  2. Average Formula based on checkbox filter
    By gan_xl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-12-2014, 10:44 AM
  3. [SOLVED] How to see the ActiveX Checkbox is checked ?
    By redsab in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2013, 04:37 AM
  4. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  5. [SOLVED] Can you filter on an ActiveX checkbox in Excel
    By Liz in forum Excel General
    Replies: 1
    Last Post: 08-12-2005, 08:05 PM

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