Ternary Operator in VBA?

Most programming languages have a ternary operator (which allows a condition to be written on a single line), usually in the following form:

condition ? if_true : if_false

Unfortunately, this operator does not exist in VBA but there's a similar function which allows you to write a condition on a line.

It's the IIf function.


To illustrate, here's a simple If condition:

Sub condition()
    age = 20
    If age >= 18 Then
        result = "adult"
        result = "minor"
    End If
End Sub

Using the IIf function, you can simplify the entry as follows:

Sub condition()
    age = 20
    result = IIf(age >= 18, "adult", "minor")

End Sub