+ Reply to Thread
Results 1 to 3 of 3

Macro to filter data to search terms selected from ComboBox (Form Control)

  1. #1
    Registered User
    Join Date
    03-01-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    43

    Macro to filter data to search terms selected from ComboBox (Form Control)

    Hi Excel Gurus,

    I just received a workable answer to another issue and sure do appreciate this forum (and AlphaFrog).

    The reason I mention this is that what I am asking will seem the same and it is similar, but it is enough different that I felt it important to start another thread.


    I am now trying to figure out how to Filter data based upon a selection from a ComboBox (Form Control).

    My attachment illustrates what I am looking for.

    If anyone knows how to do this I would very much appreciate some guidance.

    NOTE***The attachment is incorrect. I do not know how to replace it with a correct one so I will upload the correct one on a secondary post right now. Sorry and thanks for your patience.

    Thank you,
    JasonRay
    Last edited by JasonRay; 06-08-2013 at 04:58 PM.

  2. #2
    Registered User
    Join Date
    03-01-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Macro to filter data to search terms selected from ComboBox (Form Control)

    Correct Search Box using ComboBox (Form Control)test.xlsmCorrect attachment

  3. #3
    Registered User
    Join Date
    03-01-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Macro to filter data to search terms selected from ComboBox (Form Control)

    Hi guys (and gals),
    I just figured out why the attachment was incorrect. You will see the Excel Wrkbk has two wrkshts; one is labeled "Before Search" (to illustrate view all data and combobox is blank), the second one is labeled "After Search" and is used to illustrate how the document would appear after selecting the text "Suntrust Bank" from the combobox. The mistake I made was I simply copied the combobox from one sheet to the next so whatever I put in one shows up in the other. To be clear - the first sheet should show the combobox as empty and the second sheet should show the combobox has the text "Suntrust Bank" in it.

    Sorry for the inconvenience and confusion - if any.
    JasonRay

+ 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