Trouble with sub that runs on pressing enter after modifying cell's content

[luv2glyd]

I have the following sub which is designed to run another sub, "mySub", once I change the value of cell H10:

Please Login or Register  to view this content.

mySub basically goes to another workbook, modifies some values in it and comes back to the workbook where mySub resides. If I run mySub by itself, it runs fine, but if I attempt to activate it with the code above, it seems to run on a loop, going back and fourth between the two workbook endlessly. Any clues as to why? I used this code before and it worked well.

Thanks.

[LJMetzger]

Hi,

You might be modifying "H10" causing WorksheetChange() to fire again.

If this is the case, you have to tell us what you want to happen when this occurs, in order for us to provide the proper fix for your problem.

Lewis

[luv2glyd]

Ahhhaa! That could be it. As soon as I modify cell "H10" on my own, mySub goes to the secondary worksheet to do a few things, then comes back and enters another value into "H10" on its own. I did not think Excel would perceive this as me doing it. Anyway, what I'd like to have happen as soon as it comes back to the original worksheet and enters this other value on its own is to simply stop not do anything.

[shg]

Maybe ...

Please Login or Register  to view this content.

[luv2glyd]

That works! Thank you.

[LJMetzger]

Great answer as usual shg. Thanks for the rep points luv2glyd.

Sometimes you don't want to disable system events. In that case you can use a global variable of your own to inhibit something. This is a techinque used quite often in UserForms.

Lewis

Please Login or Register  to view this content.