Intersect.Target Worksheet Change Not Triggering Worksheet Change Events Associated to That Target Cell

Ark68

Well-known Member
Joined
Mar 23, 2004
Messages
4,562
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
When a user clicks a macro enabled shape in my worksheet, the code populates a value to a dynamic cell ("X#" where # is variable) on that worksheet. I have this code below, part of my worksheet change code in the worksheet module, that is supposed to trigger when that cell changes.

Code:
If Not Intersect(Target, Range("$X$" & dcomprow)) Is Nothing Then '
        Stop
        Application.ScreenUpdating = False
        mbevents = False
        Unprotect
        bdr_weather
        Protect
        mbevents = True
        Application.ScreenUpdating = True
    End If

Assume the user clicks the macro enable button. dcomprow = 24. The value determined in the button click macro is passed to cell "X24". Should that action not trigger this code? Unfortunately, it is not.

Happy for any thoughts or suggestions.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
On doing some searching, I also tried putting this code in an a Worksheet_Calculate procedure with no resolution.
 
Upvote 0
anything in your button click macro disabling events ?
 
Upvote 0
Solution
Winner winner chicker dinner.
Thanks noSparks ... turns out I had my mbevents = false which was disabling changes. Had to set it to true before the value got carried over to the cell. Took me a while to narrow down where I had to reset mbevents back to true.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top