When I use the
method for my function, I noticed that the MsgBox's that I have for the function appear in the other workbook(s) when I make a change in a worksheet. Why?Application.Volatile True
In my function the MsgBox's are in a FOR-NEXT loop, but my loop is as stated:
The MsgBox is within an IF statement and is looped (if that matters ) to repeat different values for the function I'm debugging.]For Each cmt In Application.Caller.Parent.Comments 'Code Next cmt
How can I stop this??