+ Reply to Thread
Results 1 to 10 of 10

Find Text with Macro

  1. #1
    Registered User
    Join Date
    10-28-2012
    Location
    Afghanistan, Kabul
    MS-Off Ver
    Office 2013
    Posts
    48

    Find Text with Macro

    I need a macro or something that will allow the user to type a word, name, or number, or something into a cell and then click a "find" button, that will then search the current sheet and find the data that the user typed in the cell. Anyone have an idea how to do this easily?

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Find Text with Macro

    How about:

    Please Login or Register  to view this content.
    Put your search value in A1 and run the macro.
    Last edited by Jakobshavn; 11-26-2012 at 01:15 PM.
    Gary's Student

  3. #3
    Registered User
    Join Date
    10-28-2012
    Location
    Afghanistan, Kabul
    MS-Off Ver
    Office 2013
    Posts
    48

    Re: Find Text with Macro

    This code just shows cell address. can you send me any code to find text i write in Selected Cell. I mean go to that cell by macro

  4. #4
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Find Text with Macro

    Here is a version that will get to the cell:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-28-2012
    Location
    Afghanistan, Kabul
    MS-Off Ver
    Office 2013
    Posts
    48

    Re: Find Text with Macro

    Thanks dear Jakobshavn

  6. #6
    Registered User
    Join Date
    10-28-2012
    Location
    Afghanistan, Kabul
    MS-Off Ver
    Office 2013
    Posts
    48

    Re: Find Text with Macro

    Dear! can you send me a code that i can search a specific range and cells not whole sheet.

  7. #7
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Find Text with Macro

    yes...................

  8. #8
    Registered User
    Join Date
    10-28-2012
    Location
    Afghanistan, Kabul
    MS-Off Ver
    Office 2013
    Posts
    48

    Re: Find Text with Macro

    But when you can send to me the macro code of it

  9. #9
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Find Text with Macro

    Here it is:

    Please Login or Register  to view this content.

    Note:

    The user can supply the range with the mouse or by typing the search address.

  10. #10
    Registered User
    Join Date
    10-28-2012
    Location
    Afghanistan, Kabul
    MS-Off Ver
    Office 2013
    Posts
    48

    Re: Find Text with Macro

    Thanks Dear. My problem was solved.
    Formula: copy to clipboard
    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)

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