VBA If Statement Evaluating After True

[CokeOrCrack]

Hello:

My workbook has 2 sheets, "Numbers" and "General".

I have an If statement that runs at workbook close.

    If Sheets("Numbers").Range("BA2") = 0 Then        Sheets("Numbers").Range("BA3") = "Correct"
    ElseIf Sheets("Numbers").Range("BA2") <> 0 Then
        Sheets("General").Range("A13").ClearContents
    End If

When BA2 in sheet "Numbers" is 0, BA3 shows "Correct".

The issue is that I have a Worksheet_Change sub in the "General" sheet. This sub updates a timestamp in that sheet when it is in any way changed.

After running the If statement at workbook close, the timestamp is still updating, even when BA2 = 0.

I have tried removing the above If statement, and the timestamp does not update at close without it, which confirms that the above If statement is what is causing the timestamp to update.


Question:

Is there a way to end an If statement once it is true, but continue to evaluate if it is initially false?

Thanks

OJ

 

[Scott Huish]

The Part after the Then should be on the next line, but there is no need for ElseIf, because it is either 0 or it is not.
If Then Else should suffice:

Sub test()
If Sheets("Numbers").Range("BA2") = 0 Then
    Sheets("Numbers").Range("BA3") = "Correct"
Else
    Sheets("General").Range("A13").ClearContents
End If
End Sub

 

[CokeOrCrack]

Scott:

Thank you for looking into this. I forgot the "General" sheet had a Pivot Table in it to the far right that I needed to scroll to in order to see.

I moved the Pivot Table to the "Numbers" sheet and it now works perfect.

Thanks

OJ

 

[Crystalyzer]

So basically if the first IF statement in the Workbook_Close event is true, you want to update the worksheet without invoking the Worksheet_Change event, is that correct?