Can you post your code here? The first thing I would try would be to
disable events after the first event triggers like this:

Sub Worksheet_Change(BlahBlahBlah)
Application.EnableEvents = False
'Your Code
Application.EnableEvents = True
End Sub

HTH

Die_Another_Day

nullGumby wrote:
I'm using Excel 2003 and writing some VBA code to validate cell contents.

I'm using the "Worksheet_Change" event to trap when a user modifies the
contents of a cell ($1:$D). If the contents are invalid I want to display a
message in another cell ($1:$C). While stepping through the code I find the
event fires fine, and using the following code my display cell populates fine:

Me.Cells(intRow, 3) = strErrorMessage

And I can see this new text on the screen. However, once that text is
applied again, the "Worksheet_Change" event fires again. The text remains in
there until the end of the first call to the event, then it clears out.

Is anyone aware of a problem modifying the contents of other cells, while in
the middle of the "Change" event of another? Anyone know a work around?

Thanks.