Adding another condition to this conditional if statement

Question

I have this if statement right here:

If lbl1.Text <> "Good" Or lbl2.Text <> "Good" Or lbl3.Text <> "Good" Then
        MsgBox("Something.")
        Exit Sub
    End If

This works fine, but I also need to attach another condition to it, but for some reason I am drawing a blank on it. I need it to also pass that it is ok for lbl2 & lbl3 to be an empty string. In order words, if lbl1.text = "Good" then it is ok for lbl2 & lbl3 to be empty, therefore it will not exit sub.

John Bustos · Accepted Answer · 2016-06-10 13:20:54Z

2

If you look at it from the other way around, what you're saying is that if any one of the labels says "Good", then don't enter this statement, so, you could say enter this statement if that is not the case.

In other words:

If Not(lbl1.Text = "Good" Or lbl2.Text = "Good" Or lbl3.Text = "Good") Then
    MessageBox.Show("Something.")
End If

Hope that does the trick!

answered Jun 10, 2016 at 13:20

John Bustos

19.7k18 gold badges102 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

RockGuitarist1 Over a year ago

I always forget about If Not. I gotta get out of the habit of trying to fit the conditions with <>

Capellan · Accepted Answer · 2016-06-10 13:20:36Z

1

What about a statement like this?

If Not ((lblA.Text = "Good" OrElse lblA.Text = String.Empty) AndAlso _
            (lblB.Text = "Good" OrElse lblB.Text = String.Empty) AndAlso _
            (lblC.Text = "Good" OrElse lblC.Text = String.Empty)) Then
        MessageBox.Show("Something.")
    End If

edited Jun 10, 2016 at 13:20

answered Jun 10, 2016 at 13:14

Capellan

7006 silver badges17 bronze badges

1 Comment

RockGuitarist1 Over a year ago

Dropped the Exit Sub in there and this did what I needed. Thanks for the help!

Collectives™ on Stack Overflow

Adding another condition to this conditional if statement

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related