VBA another way to write or statement

anthonyexcel · Jun 30, 2019

Good morning,

I am pretty new to VBA. Just wondering is there a shorter way to write multiple or's in VBA. Thanks in advance

Code:

If (gradelevel = 1 Or gradelevel = 2 Or gradelevel = 3 Or gradelevel = 4 Or gradelevel = 5 Or gradelevel = 6) Then

Fluff · Jun 30, 2019

You could use a Select Case Statement, like

Code:

    Select Case gradelevel
        Case 1 To 6
            'do something
    End Select

Rick Rothstein · Jun 30, 2019

Another way...

Code:

If gradelevel Like "[1-6]" Then

And yet another way (although this would pass floating point values if your gradelevel is not guaranteed to be integer)...

Code:

If gradelevel > 0 and gradelevel < 7 Then

anthonyexcel · Jun 30, 2019

Thank you both!! I appreciate any guidance that I can get!! Have a great evening!

Fluff · Jul 1, 2019

Glad we could help & thanks for the feedback