Using Option Buttons as An AutoFilter

[siamadu]

I have an excel spreadsheet with a list of inventory parts. As many of
you know, there could be thousands and thousands of parts in any given
inventory.

Instead of using the ordinary filter to drill down to the actual item,
I would like to create a custom made user form to do the filtering.


Here is the set-up:

1. Select the type of part(column #1)
2. Select the type of data you want to search in (this would be any
other column)
3. Narrow down the search by entering a keyword.

One worksheet will have the user form
One worksheet will have the parts

I would like build a code that will do the filtering from the user
form. Then display the results below the user form.

I have attached a copy of my excel worksheet and the user form.


+-------------------------------------------------------------------+
|Filename: Parts Test.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=76|
+-------------------------------------------------------------------+

 

[Leith Ross]

Hello siamadu,

Welcome to the Code Cage!

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

--
Leith Ros

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/

 

[siamadu]

Hello siamadu,

Welcome to the Code Cage!

I have looked at your UserForm and wanted to ask you if you want t
return only the first match or all matches. Were do you want the result
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 narro
down to be filtered by each one of the columns.

The first filter is to select the type of part that the user wants t
research.
The second filter is to select the column the user once to use t
conduct his/her search.
Then once the user selects the column, then he/she will enter in
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 th
inventory database to be on another sheet. I do not want the user t
have any access to the inventory database sheet

You see, this will be used for inventory. And inventory can hav
hundrerds and hundreds of lines to search. The first search i
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 t
narrow down the search will be help.

Sorry to be so long-winded. I just want to make my self clear. I hav
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
+-------------------------------------------------------------------