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

Ark68

Well-known Member
Joined
Mar 23, 2004
Messages
4,352
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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Ark68

Well-known Member
Joined
Mar 23, 2004
Messages
4,352
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
On doing some searching, I also tried putting this code in an a Worksheet_Calculate procedure with no resolution.
 

NoSparks

Well-known Member
Joined
Mar 15, 2013
Messages
1,454
Office Version
  1. 2010
Platform
  1. Windows
anything in your button click macro disabling events ?
 
Solution

Ark68

Well-known Member
Joined
Mar 23, 2004
Messages
4,352
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,175,769
Messages
5,899,372
Members
434,766
Latest member
PremPrakash

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
Top