when using InStr function, it fills the target cell repeating info

I have the following code. I want it just to use InStr to find if a certain expression is contained within the cell, and if so perform a simple highlight action then add the date to the end of the cell's text.

used in the Sheet 'Change' event:

Please Login or Register  to view this content.

but i just get the cell filled up with the current date/time until it can't fit anymore repeats

i've tried using target.cells.value instead of activecell, and declaring a variable with the instr value, or using a variable with the cell value inside the InStr syntax, but it always happens

i'm a bit confused

anyone know what's going on?

appreciate any help

You're retriggering the change event when you change the cell in the event code. Not sure what logic you want, but maybe this:

Please Login or Register  to view this content.

ah, genius
works great
thanks