Worksheet_Change event doesn't fire when VBA code writes into a cell

Question

Hello,

during some tests with Excel for Mac I've found that the Change event doesn't fire if another macro changes a cell.

To reproduce this issue:

• Make a new file
• Add this code to the code module of the active sheet

Private Sub Worksheet_Change(ByVal Target As Range)

  MsgBox Target.Address(0, 0)

End Sub

• Add a regular module, add this sub

Sub Test()

  Application.EnableEvents = True

  Range("A1") = 1

End Sub

• Close the VBA editor and run Sub Test

Every Windows version of Excel triggers the Change event, but not on Mac?

Bug? Feature? Is there something on Mac that I'm missing?

Andreas.

Answer 1

No, there is nothing you are missing. It is a Mac bug reported over and over again throughout  the past 10 years or so. Microsft has apparently decided that it is not important enough to fix. You can add your 2 cents by sending feedback from the help menu. Maybe one more input will tip the scales. However, it appears to have been fixed in Excel 2016.