View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_3_] Alan Beban[_3_] is offline
external usenet poster
 
Posts: 130
Default Check if a String is inside an Array

No; but if the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, the coding
can look simpler (the looping is within the function):

Replace the loop with
If ArrayCountIf(MyArray, A) 0 Then _
MsgBox "it's there" Else MsgBox "it's not"

Alan Beban

Luis Carrion wrote:
Hi,
If I were to check if a variable: A="Test" is inside a list of
possible strings,Iīll do this:

Dim A as string
Dim B as variant
Dim MyArray As variant

MyArray=Array("Test", "This")
For Each B in MyArray
If A=B then Msgbox "Itīs inside the group
Next A

Is it possible to test this in other way; something like this
If A is in/like MyArray then....... ---without looping inside the
array

Thanks.
LC