devxlogo

CompareList – Compare an argument with a list of values

CompareList – Compare an argument with a list of values

' Return the position of the argument in a list of values' or zero if the argument isn't included in the list' It works for both regular values and for objects'' This handy function can often save you a lengthy Select Case' statement or a complex series of If...ElseIf blocks'' Example: check whether a string is a valid continent name'     If CompareList(aString, "America", "Europe", "Asia", "Africa",'  "Australia") > 0 Then MsgBox "OK"Function CompareList(ByVal Arg As Object, ByVal ParamArray Values() As Object) _    As Integer    Return Array.IndexOf(Values, Arg) + 1End Function

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist