Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing a string againsts a list of strings
Does VB for Excel have a method of testing a string to see if it matches a
list of strings similar to "If... Statements"? I would still need to perform an action if the statement is true (or false depending on the logic). If so, I would assume the opposite can be done... see if "String" is one of the list of strings. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing a string againsts a list of strings
Hi,
Am Thu, 14 Nov 2013 13:01:25 -0600 schrieb JCO: Does VB for Excel have a method of testing a string to see if it matches a list of strings similar to "If... Statements"? I would still need to perform an action if the statement is true (or false depending on the logic). are your strings into the sheet? Then you could use Worksheetfunction.CountIf Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing a string againsts a list of strings
Yes they are. This will work.
Thanks again. "Claus Busch" wrote in message ... Hi, Am Thu, 14 Nov 2013 13:01:25 -0600 schrieb JCO: Does VB for Excel have a method of testing a string to see if it matches a list of strings similar to "If... Statements"? I would still need to perform an action if the statement is true (or false depending on the logic). are your strings into the sheet? Then you could use Worksheetfunction.CountIf Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
testing url string | Excel Programming | |||
Min Date againsts unique customer list | Excel Worksheet Functions | |||
testing for character strings within a cell | Excel Worksheet Functions | |||
testing for a string type | Excel Programming | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions |