Nested If in VBA

Question

I've been tasked to correct someones code in VBA. I've never VBA programmed before so this is very basic.

Am I correct in assuming that after the first Then it checks if the next condition is true and thats where it executes the last line?

    If data.Cells(i, 3 + 4).Value <> "" Then

    If data.Cells(i, 2 + y).Value <> "" Then
        tilqa = data.Cells(i, 2 + y)
    End If

You can add this line Option Explicit to the top of the VBA file, it will help get compilation errors, See Option Explicit Statement — Jonathan Larouche
– Jonathan Larouche, Commented Oct 24, 2019 at 11:32
In the VBA IDE you can place the cursor on any keyword and press F1. This will bring up the MS Help page for that particular keyword. I — freeflow
– freeflow, Commented Oct 24, 2019 at 11:56

Vityata · Accepted Answer · 2019-10-24 11:53:49Z

1

Whenever you have a question about the functioning of a code, try to write a small example, like the one below, with MsgBox(), showing exactly what is happening. The 1=1 and 2=2 is always evaluated to True:

Sub TestMe()

    If 1 = 1 Then
        If 2 = 2 Then
            MsgBox "First check here!"
        Else
            MsgBox "This is not checked!"
        End If
        MsgBox "Then check here!"
    End If

End Sub

Amd this is how the If-Else-End If may function without Else:

Sub TestMe()

    If 1 = 1 Then
        If 2 = 2 Then
            MsgBox "First check here!"
        End If
        MsgBox "Then check here!"
    End If

End Sub

edited Oct 24, 2019 at 11:53

answered Oct 24, 2019 at 11:32

Vityata

43.8k10 gold badges64 silver badges110 bronze badges

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

2 Comments

pam_param Over a year ago

Can you write a conditional statement without an Else? Because that's what my code does and I'm not sure what's happening

Vityata Over a year ago

@SaimNazir - I have edited, adding the option without Else. In general, simply give it a few tries, delete a few lines and experiment with the code. This is the best way to learn what is happenning.

Collectives™ on Stack Overflow

Nested If in VBA

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related