What event to use?

[akeeping]

I have a macro that writes the results of formula into another cell location. Ideally, this should happen whenever the contents of a particular input cell change. I hooked the macro to the "worksheet_change" event. Not suprisingly, when it fires, it continues to loop since the macro is generating a "change" event. Any thoughts??

 

[Barrie Davidson]

On 2002-09-29 05:59, akeeping wrote:
I have a macro that writes the results of formula into another cell location. Ideally, this should happen whenever the contents of a particular input cell change. I hooked the macro to the "worksheet_change" event. Not suprisingly, when it fires, it continues to loop since the macro is generating a "change" event. Any thoughts??

Put this before your code:
Application.EnableEvents = False

and put this at the end of your code (very important to include this):
Application.EnableEvents = True

Regards,