+ Reply to Thread
Results 1 to 4 of 4

InStr inside a case statement

  1. #1
    Forum Contributor
    Join Date
    03-11-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2016 (among others!)
    Posts
    331

    InStr inside a case statement

    So just trying to put together a quick little function. It basically picks up the text in a cell and then it will look for certain phrases for the answers.

    The code I've got is:
    Please Login or Register  to view this content.
    The first line in my sheet has PAYSAFE in it but it still returns no value. Thinking my syntax is slightly off but can't honestly see it. CAn anyone help?

    TIA

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: InStr inside a case statement


    Select Case True

  3. #3
    Forum Contributor
    Join Date
    03-11-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2016 (among others!)
    Posts
    331

    Re: InStr inside a case statement

    And just like that! Many thanks.

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: InStr inside a case statement


    Thanks for the rep' !

+ 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] Select Case with multiple lines in a case statement?
    By jGKpZ8a33sPrnqX8fam7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-02-2017, 10:25 AM
  2. [SOLVED] Help with Select Case and InStr?
    By smpita in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-16-2014, 02:05 PM
  3. Replies: 4
    Last Post: 03-27-2013, 12:16 PM
  4. [SOLVED] Case inside a Case throws error 424
    By Jon.R in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2013, 12:36 AM
  5. [SOLVED] InStr()/Select Case [Excel VBA 2010]
    By lloydgodin in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-09-2012, 12:59 PM
  6. SELECT CASE with INSTR is it possible???
    By dwr0211 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2011, 06:50 PM
  7. INSTR for a case statement
    By goofy78270 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2007, 07:06 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