Thread: Testing a string againsts a list of strings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default 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
Reply With QuoteReply With Quote