+ Reply to Thread
Results 1 to 9 of 9

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

  1. #1
    Registered User
    Join Date
    11-28-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    75

    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
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    445

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

    Try something like this...
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,808

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

    Quote Originally Posted by 123wc View Post
    ... 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
    Attached Images Attached Images
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,188

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

    Quote Originally Posted by 123wc View Post
    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.

  5. #5
    Registered User
    Join Date
    11-28-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    75

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

    WOW! You guys are great!!!

  6. #6
    Registered User
    Join Date
    11-28-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    75

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

    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!

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,188

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

    Quote Originally Posted by 123wc View Post
    Here's the second part of it:
    And the third, forth, fifth...etc?

  8. #8
    Registered User
    Join Date
    11-28-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    75

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

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

    Thanks in advance!

  9. #9
    Valued Forum Contributor
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    445

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

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Search for cell value; look up last number value in row, sum those values
    By Gregbaron in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2017, 08:48 PM
  2. [SOLVED] Need Loop to Search for cell containing two values
    By theOctonaut in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-27-2015, 04:39 PM
  3. Search cell text and output different values based on result in another cell
    By tbarn1980 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2013, 09:54 PM
  4. search cell values based on list of values in other sheet and add color to row
    By darkbraids in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2012, 08:35 AM
  5. VB input box to search and changes values within a cell
    By Absent in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-06-2012, 09:22 PM
  6. search a cell for values in a range, return values found
    By carpe.cervisiam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2011, 12:52 PM
  7. search cell if blank delete cell shift values up
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2009, 10:01 PM

Tags for this Thread

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