+ Reply to Thread
Results 1 to 3 of 3

Using a loop to identify a string value

  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Using a loop to identify a string value

    Hi all,
    i'm trying to create a loop to identify 1 of 5, msg strings

    Please Login or Register  to view this content.
    For some reason the value for xmsg = "msg1, msg2, msg3, msg4 or msg5" and not the stated string value that each msg has been assigned.

    Any help is appreciated.

    Thanks,

    BDB
    Last edited by bdb1974; 01-24-2012 at 06:56 PM.

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Using a loop to identify a string value

    bdb1974,

    I see what you're trying to do, and unfortunately it doesn't work that way. You'll have to use an array instead to get the desired results. Give this a try:
    Please Login or Register  to view this content.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Using a loop to identify a string value

    Thanks tigeravatar!

    That's exactly what I was trying to accomplish. I had thought about using an array, but didn't know it would make a difference. But, it did.

    Thanks again.

    BDB

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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