+ Reply to Thread
Results 1 to 3 of 3

Doubt with Autofilter (VBA)

  1. #1
    Registered User
    Join Date
    09-12-2008
    Location
    Riversul
    MS-Off Ver
    2016
    Posts
    83

    Doubt with Autofilter (VBA)

    Hello, I'm currently trying to develop a sheet where our clients could select an item that would work as a criteria for a filter (based on a validation list) and the desired results would automatically be displayed on the screen.

    Well, through the help of a few tutorials on the web I've managed to advance a little bit but I still have a major problem (that can be best explained through an example I've attached in this message). I've been asking myself: What if the clients wants to see all the results instead of the filtered ones? Well, they could simply turn off the filter, right? Sure, they can certainly do that. But what if they're not interested to select the filter range everytime they need to turn it off and then just send me to hell?

    I tried many different ways to be able to auto specify that range but my efforts were simply in vain. If anyone could please take a look on it and then suggest a solution for that problem, I'd be very grateful. Thank you!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Doubt with Autofilter (VBA)

    try
    Please Login or Register  to view this content.
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Registered User
    Join Date
    09-12-2008
    Location
    Riversul
    MS-Off Ver
    2016
    Posts
    83

    Re: Doubt with Autofilter (VBA)

    Hello tehneXus, thank you very much, it worked! Thanks to you the clients won't send me to hell anymore haha. Take care, wish you all the best!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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