+ Reply to Thread
Results 1 to 2 of 2

Userform Multi Criteria search

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    California, US
    MS-Off Ver
    Excel 2007
    Posts
    2

    Userform Multi Criteria search

    So i am new to VBA but i am starting to get teh hang of it a little. I need help though...I am sorry if it is a dumb question

    So i have a userform that searches a database that i have on Sheet 1 called Main. The userform has two text boxes(User ID, Model Number) and two combo boxes(Issue, Issue Type). It will search the database in sheet one for any of the criteria. If nothing is inputed itll will show nothing. if only one criteria is inputed itll show every record based on that criteria. So for example they only search for the User ID us444444 for example, itll show every record with the user id us444444.

    I tried and had it successfully paste the results onto sheet two called Results. But it didnt search correctly. I would like it if the user searched a different criteria, the previous results would erase and the new results would be copied to the results page.

    Please Help meeee.

    Any help would be greatly appreciated.

    EXAMPLE.xlsm

  2. #2
    Registered User
    Join Date
    07-10-2012
    Location
    California, US
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Userform Multi Criteria search

    And im new to Excel forum

+ 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