ActiveX

To monitor data changes

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Using the SetCellDirtyFlag method,
   1. Set the Col parameter to the column number of the cell to monitor, or set the value to –1 to specify an entire row.
   2. Set the Row parameter to the row number of the cell or cells to monitor.
   3. Set the Dirty parameter to TRUE to flag changed cells.
3. Use the GetCellDirtyFlag method to check whether a specific cell's data has been changed.