Testing a string againsts a list of strings

J

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).

If so, I would assume the opposite can be done... see if "String" is one of
the list of strings.

Thanks
 
C

Claus Busch

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).
Click to expand...

are your strings into the sheet? Then you could use
Worksheetfunction.CountIf


Regards
Claus B.
 
J

JCO

Yes they are. This will work.
Thanks again.

Claus Busch said:
Hi,

Am Thu, 14 Nov 2013 13:01:25 -0600 schrieb JCO:


are your strings into the sheet? Then you could use
Worksheetfunction.CountIf


Regards
Claus B.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

locate blocks of text in one word file and paste in other locations in another word file 1
Word macro that can call cells out of Excel for a find and replace 0
VBA Export to PDF 0
Claus code works on my data not on OP's data 2
Pass "array of strings" into a function?? 1
Sort a range of strings using VBA code? 5
Making a macro only work on certain files 2
VBA - exporting serial letters to single documents 0

Top