CODEWITHSUNDEEP
vbaexcel
NewDev
NewDev

Reputation: 375

Recursive call on the worksheet change in VBA

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.

Upvotes: 3

Views: 3786

Answers (2)

El Ronnoco
El Ronnoco

Reputation: 11922

Put a new global variable in a Module and call it bAutoUpdating As Boolean for example.

When the _Change code runs it should set this to true. Also any change routine should not fire if this is true. At the end of each _Change routine set back to bAutoUpdating = false

Upvotes: 1

JMax
JMax

Reputation: 26591

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

Upvotes: 9

Related Questions