Limit of OR operators in one IF Statement

[kpark91]

Hello, I was wondering if there is a maximum number of OR operators I can use in one IF statement.

 

[MrKowz]

Hello, I was wondering if there is a maximum number of OR operators I can use in one IF statement.

Not that I'm aware of, just a limited number of nested statements (and a limit to how long a formula can be). However, there may be a better, easier, way to handle this IF statement rather than using a bunch of ORs.

Could you please describe what you are needing to do?

 

[jasonb75]

Depends how you're trying to write the formula.

If I remember correctly, excel 2003 has a limit of 7 levels of nesting or 30 arguments, excel 2007 / 2010 allows 64 levels or 255 arguments.

 

[kpark91]

OIC. Thank you very much for the explanation.

is there a maximum in VBA?

Could you please describe what you are needing to do?

Well, I have a userform with alot of textboxes where the user can input.
Without the textboxes being filled, the user cannot proceed to the next form.
So, I was meaning to create an if statement to determine if any of the textboxes are empty through OR operators.

But then, I realized I can just loop through the textboxes in one userform and here is the code I have used which have been modified from Excel VBA website code.

    Dim cCont As Control
 
    For Each cCont In UserMenu.Controls
        If TypeName(cCont) = "TextBox" Then
            With cCont
                If Trim$(.Text) = vbNullString Then
                    MsgBox "All fields must be filled in", vbCritical
                    Exit Sub
                End If
            End With
        End If
    Next cCont
 
    UserMenu.Hide
    Application.Wait 10000
    Load MainMenu
    MainMenu.Show

Is there any errorhandling I must do in this code?
Please and thank you again