+ Reply to Thread
Results 1 to 4 of 4

Match string Array with InStr function

  1. #1
    Registered User
    Join Date
    08-12-2013
    Location
    Denton, Texas
    MS-Off Ver
    Excel 2010
    Posts
    89

    Match string Array with InStr function

    Hello Everyone,

    I'm trying to build a list of words in an Array and have the program search a paragraph in a Textbox and look for matching words from the Array and make the next move.
    Basically, the user writes a paragraph and I use a thesaurus(synonyms) for the word "change" and if the user uses one of the words in that paragraph then I use an "If Statement".
    I wanted to go the Array route for speed but don't know if I'm correct.

    Below is my wimpy attempt

    Any help is greatly appreciated! Thank you!




    Please Login or Register  to view this content.

  2. #2
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Match string Array with InStr function

    Hi Jquintana83,

    Check the following code and hope this will help you:


    Please Login or Register  to view this content.

    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

  3. #3
    Registered User
    Join Date
    08-12-2013
    Location
    Denton, Texas
    MS-Off Ver
    Excel 2010
    Posts
    89

    Re: Match string Array with InStr function

    Hey Paresh,

    Thats it! Perfect thank so very much, you solved it!

  4. #4
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Match string Array with InStr function

    Hi jquintana83,

    You are welcome !!! Glad I could help you.
    Dont forget to click on * Add Reputation as way to say thanks!!!


    Regards,
    Paresh J

+ 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] Instr to look for a complete, exact match of a string
    By SandPounder1 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-30-2014, 03:50 PM
  2. Match String to an Array
    By Don2013 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2013, 06:10 PM
  3. InStr function using an array
    By SOS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-18-2011, 08:58 AM
  4. Instr Function - Replace String 2 with Variables?
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-08-2010, 03:14 PM
  5. Defining string using InStr function help
    By Iwant2learn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-13-2006, 12:29 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