Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I have a cell that when changed triggers a worksheet change event. This works wonderfully when a user physically changes the cell value with the data validation list selection.
But I have instances where the value of the cell is changed via code.
eg
I need that change to also trigger the worksheet change event. Is this possible?
But I have instances where the value of the cell is changed via code.
eg
Code:
sheets("sheet1").range("A1") = "test"
I need that change to also trigger the worksheet change event. Is this possible?