Worksheet_Change only works once

[yuechenz]

Hi,

I am trying to recalculate macro functions called from F8:O115 if any value in B2:O4 is changed.
But the recalculation only works once after compile. The second time I change any value in B2:O4 nothing will happen..

There must be something wrong in the code below, but I can't figure it out

Please Login or Register  to view this content.

[Gervie]

Hi,

I have used your code. It's good.
I think the second time you change and nothing happen because you played macro in break mode. You can see this in below picture.

untitled-8.jpg

In picture, I have played line-6 code in break mode. And I think you have stopped macro before VBA code played line "Application.EnableEvents = True". In this case, your Application.EnableEvents = False so Worksheet_Change event couldn't execute.

To solve this problem, you should use Immediate Window (Ctrl + G) -> write Application.EnableEvents = True in it -> Enter. After you do this, VBA will enable events to execute. I believe the third time you change any value, Worksheet_Change will work smoothly.