Results 1 to 9 of 9

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

Threaded View

  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

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