Why does thjs code trigger another

[Giordano Bruno]

I have a userform with a textbox and a listbox. In the form's code module I have the following code:

Private Sub tbxAB_AfterUpdate()
shtCorrel3.Range("ValidMax").Calculate
End Sub

This code immediately triggers the procedure, "Private Sub lbxSource_Change()".
The calculation of the single cell {ValidMax) is unrelated to the Listbox source. Can anyone explain why it starts the second code and just as importantly how to stop it doing so?

 

[Jaafar Tribak]

See if this workaround works for you :

Private Sub tbxAB_AfterUpdate()
    lbxSource.Tag = "Calculating"
    shtCorrel3.Range("ValidMax").Calculate
    lbxSource.Tag = ""
End Sub

Private Sub lbxSource_Change()
    'Skip if calculating
    If lbxSource.Tag = "Calculating" Then Exit Sub

    'Your change code code goes here.
End Sub

 

[Giordano Bruno]

Brilliant Rory. I could have thought of that, but I didn't. That's a really neat solution which ticks all the boxes. Thank you again for completing the puzzle for me.