+ Reply to Thread
Results 1 to 7 of 7

Search column A using iput box

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Search column A using iput box

    Hello everybody
    I have large data in column A .. there are a lot of similar data ..
    When use Find built-in method to find specific string, I got a lot of results ..
    So I'm searching for a way to search using two string or more .. I mean I need to type in inputbox two or more strings and activate the cell that matches the search.

    For example, in the attachment ...
    I will type two words in input box (help search) ...
    when I run the code I expect to activate A3 as this cell contains the two words ...(no matter about case sensitive)
    when I run the code again .. the code to activate the next search result which is A11 (note that the string "search" is just part of the word "Searches"

    Another example: if I typed in the input box two words (please me)
    I expect to acivate A3 then after running again A9 then after running the code A12

    if there is no results for the search to have a message

    Hope it is clear
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Search column A using iput box

    Try this:

    It will search every cell after the active cell.

    Please Login or Register  to view this content.
    Last edited by ARowbot; 08-05-2015 at 09:11 AM.
    !If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
    If I helped do this, then please show your appreciation by awarding rep points.
    <------ Button for that is over there

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Search column A using iput box

    Thank you very much Mr. ARowbot for this great solution.
    I just need a little modification ... as I found this will be exhausted also

    I need to hide all the rows and to let all the rows that match the results to be unhidden
    Thanks advanced

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Search column A using iput box

    Is it possible to hide all rows except for the rows that match the results of search?

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Search column A using iput box

    Thanks I could fix it to suit me
    Please Login or Register  to view this content.

  6. #6
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Search column A using iput box

    or maybe this
    Attached Files Attached Files

  7. #7
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Search column A using iput box

    Thanks a lot Mr. Nilem for this simple and effective method
    Thank you very much

+ 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. Search column for string and date then search adjacent cell and pop up message
    By ftwobtwo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2014, 09:55 AM
  2. [SOLVED] Search within a column and repeat the search until all items are found
    By RANDY LIPOSKY in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-09-2014, 10:23 AM
  3. Replies: 6
    Last Post: 05-21-2013, 04:57 PM
  4. [SOLVED] Match search terms, and add data in next column. Multi search problem.
    By Wales MB in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-23-2013, 06:10 PM
  5. Replies: 4
    Last Post: 12-21-2012, 10:35 AM
  6. [SOLVED] Search in a row for a column number after a Vlookup search.
    By Fiebuls in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-11-2012, 04:25 AM
  7. Replies: 1
    Last Post: 07-26-2011, 06:48 AM

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