+ Reply to Thread
Results 1 to 2 of 2

Double advanced filter and combobox population

  1. #1
    Forum Contributor
    Join Date
    05-20-2008
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    168

    Double advanced filter and combobox population

    I have attached my work so far but have got to a point where I am not sure what I want to do is possible.

    In the frame 'CL Criteria' the user will select the material, modality, form & design for both the right and left CL.

    When they then click on 'Search' , is it possible for VBA to filter the list of CL's on the 'CL Data' worksheet for the Right Lens criteria and populate the 'Lens Choice' combobox with the results (name only), and to then repeat with the Left Lens criteria?

    I would then need the original list on 'CL Data' to be cleared of filters.

    Update: Solved it myself. Thanks to those who looked.
    Attached Files Attached Files
    Last edited by Andrew-Mark; 04-01-2010 at 08:01 AM.

  2. #2
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Double advanced filter and combobox population

    Hi Andrew-Mark

    One of the many things we mere mortals tend to forget is that there are no new problems in our "world", only different solutions. Someone, somewhere has faced the same issue you raised in this post. I know I have and I've developed different work-arounds with temporary sheets, etc. I subscribed to this thread for just that reason. I wanted to see what the experts offered as a solution.

    It would be kind if you would share your solution to the issue.

    Thanks, John
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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