Search for (1), (2), (3) values in one cell

Hello,

I have a datebase of hardware, those hardware have description, one description per cell.

How can I create a macro with a user interface so the user can search for (1), (2), or (3) values in the description column? Then maybe highlight the row that matches the description.

Example:

Row 1: 18-8 Stainless Steel Socket Head Screw (Hex Drive), M8 x 1.25 mm Thread, 16 mm Long
Row 2: 18-8 Stainless Steel Socket Head Screw (Hex Drive), M2.5 x 0.45 mm Thread, 5 mm Long
Row 3: 18-8 Stainless Steel Flat Head Screw (Hex Drive), M5 x 0.8 mm Thread, 12 mm Long

I want the user to be able to search for [18-8] + [hex] + [M5], then Row 3 is highlighted.

Is this doable?

Thank you very much in advance for any help

Try something like this...

Please Login or Register  to view this content.

Originally Posted by 123wc

... How can I create a macro with a user interface ... ?

simply,
two beer or not two beer,
one or more bars of chocolate,
hang a sign on the door to the room with the words "man at work"
... and to the work


For example:

1. Standard module

Please Login or Register  to view this content.

2. UserForm module

Please Login or Register  to view this content.

3. UserForm
Maybe like in the image and "xls" file below ... or maybe different

4. Pictures of "hardware" in appropriate resolution

5. In the archive there is a "database" file and an example directory with pictures

Originally Posted by 123wc

I want the user to be able to search for [18-8] + [hex] + [M5], then Row 3 is highlighted.

Simple use of CF.

Please Login or Register  to view this content.

WOW! You guys are great!!!

Here's the second part of it:

When I click search, say there are returned values Row 64 and Row 137 [both are highlighted]. Is there a way to keep the search portion floating so when I click search once it takes me to Row 64 and when I click search again it takes me to Row 137?

Also, is there a way to search for Hardware Type (Column B) and String 1 + String 2 + String 3?

Thank you very much! You guys are great!

Originally Posted by 123wc

Here's the second part of it:

And the third, forth, fifth...etc?

How can I make the macro look for a string regardless if the letters are caps or not?

Thanks in advance!

Please Login or Register  to view this content.