Switch Function

Prikazuje listu argumenata, sadržavajući izraze praćene vrijednostima. Switch funkcija vraća vrijednost koja je pridružena sa izrazom koji je prošao ovom funkcijom.

Syntax:


Switch (Expression1, Value1[, Expression2, Value2[..., Expression_n, Value_n]]) As Variant

Parameters:

The Switch function evaluates the expressions from left to right, and then returns the value that is assigned to the function expression. If expression and value are not given as a pair, a runtime error occurs.

Expression: The expression that you want to evaluate.

Value: The value that you want to return if the expression is True.

In the following example, the Switch function assigns the appropriate gender to the name that is passed to the function:

Error codes:

5 Invalid procedure call

Example:


Sub ExampleSwitch
Dim sGender As String
    sGender = GetGenderIndex( "John" )
    MsgBox sGender
End Sub
 
Function GetGenderIndex (sName As String) As String
    GetGenderIndex = Switch(sName = "Jane", "female", sName = "John", "male")
End Function

Choose Function

Select...Case Statement