malik641
08-05-2005, 11:38 AM
When I use the
Application.Volatile True
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?
In my function the MsgBox's are in a FOR-NEXT loop, but my loop is as stated:
]For Each cmt In Application.Caller.Parent.Comments
'Code
Next cmt
The MsgBox is within an IF statement and is looped (if that matters :dunno ) to repeat different values for the function I'm debugging.
How can I stop this??
Application.Volatile True
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?
In my function the MsgBox's are in a FOR-NEXT loop, but my loop is as stated:
]For Each cmt In Application.Caller.Parent.Comments
'Code
Next cmt
The MsgBox is within an IF statement and is looped (if that matters :dunno ) to repeat different values for the function I'm debugging.
How can I stop this??