VBA "Any" logical operator
<p>Is there a VBA operator that checks if any of the arguments evaluates to true? I dislike the syntax of having to write <code>And</code> or <code>Or</code> so many times for multiple arguments, especially for buttons that have a "select all/deselect all" type of functionality.</p>

<p>Ex.</p>

<pre><code>If checkbox1 = True Or checkbox2 = True or ... checkbox10 = True Then
</code></pre>

<p>Could this be written more succinctly as</p>

<pre><code>If Any(checkbox1, checkbox2 , ..., checkbox10) Then
</code></pre>

<p>?</p>

<p>Also, are there any performance considerations to writing such a long if statement? I noticed that after adding this macro or VBA code, my Access form loads more slowly, don't know if it has anything to do with this.</p>

<p>EDIT</p>

<p>I tried testing the suggested code below</p>

<pre><code>Public Sub text_x()
Dim a, b, c, d, e, f, g, h, i, result As Boolean
Dim t1, t2 As Single

a = False
b = False
c = False
d = False
e = False
f = False
g = False
h = False
i = True

t2 = Timer
For i = 1 To 10000000
    result = False
    If a Or b Or c Or d Or e Or f Or g Or h Or i Then
            result = True
    Else
            result = False
    End If
Next
t2 = Timer - t2


t1 = Timer
For i = 1 To 10000000
    result = False
    Select Case True
        Case a, b, c, d, e, f, g, h, i
            result = True
        Case Else
            result = False
    End Select
Next
t1 = Timer - t1


MsgBox ("Timer1 " &amp; t1 &amp; vbCrLf &amp; "Timer2 " &amp; t2)
End Sub
</code></pre>

<p>However, the timing depends on which one I put first in the code (t1 or t2). Why is this?</p>