Private Sub Command1_Click()
Dim A As Integer
A = 50
If isExist(A, "5,8,9,10,50") Then
MsgBox "Yes"
Else
MsgBox "Not"
End If
End Sub
Function isExist(num As Integer, S As String) As Boolean
Dim Ary, N
Ary = Split(S, ",")
For Each N In Ary
If num = Val(N) Then
isExist = True
Exit Function
End If
Next
isExist = False
End Function