工作表上的递归调用在VBA中发生变化 [英] Recursive call on the worksheet change in VBA

问题描述

我已经创建了多个工作表，我试图在 Sheet1 上使用WorkSheet_Change，即sheet1上的更改被复制到sheet2。同样，如果任何变化到 Sheet2 ，我也想在 Sheet1 上进行类似的更改。

I have created the workbook with multiple sheet, i am trying to use WorkSheet_Change on Sheet1, i.e. something change on sheet1 is getting copied to sheet2. Similarly if anything change to Sheet2 i want to make similiar change on Sheet1 as well.

在这两个表上都有递归调用，请让我知道如何避免这种情况。

On doing so there is recursive call on both sheet please let me know how i can avoid this.

推荐答案

调用您的宏时，您应该禁用事件：

you should disable events when calling your macro:

Sub Donot_Fire_Events()
    Application.EnableEvents = False
    ' Coding to skip these events
    Application.EnableEvents = True
End Sub

这篇关于工作表上的递归调用在VBA中发生变化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！