Leith Ross;227706 Wrote:
Hello siamadu,

Welcome to the Code Cage!

I have looked at your UserForm and wanted to ask you if you want to
return only the first match or all matches. Were do you want the results
to display - on the UserForm in a ListBox or on another worksheet?

I hope I am not asking for to much, but I would like the data to narrow
down to be filtered by each one of the columns.

The first filter is to select the type of part that the user wants to
research.
The second filter is to select the column the user once to use to
conduct his/her search.
Then once the user selects the column, then he/she will enter in a
keyword in the text box to further near the search.

I would like the results to show on the bottom of the user form and the
inventory database to be on another sheet. I do not want the user to
have any access to the inventory database sheet

You see, this will be used for inventory. And inventory can have
hundrerds and hundreds of lines to search. The first search is
necessary because they will need to know what type of part they need.
Then they will need to know how they will like to search for the part.

Once select how they want to search, simply type in any keyword to
narrow down the search will be help.

Sorry to be so long-winded. I just want to make my self clear. I have
also include another visual to see how the format should be.


+-------------------------------------------------------------------+
|Filename: UserForm Advance Filter.doc |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=77|
+-------------------------------------------------------------------+

--
siamadu
------------------------------------------------------------------------
siamadu's Profile: http://www.thecodecage.com/forumz/member.php?userid=128
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=63319