Change Event
Applies To
fpSpread control
Description
Occurs when the user modifies the contents of a cell.
Syntax
afx_msg void OnChangefpSpread(UINT, int, CWnd*, LPVOID);
Sub fpSpread_Change(ByVal Col As Long, ByVal Row As Long)
Parameters
The following parameters are available:
Parameter | Description |
---|---|
Col | Column number of cell with change |
Row | Row number of cell with change |
Remarks
This event also occurs if any dependent cell in a formula changes. For example, cells A1, B1, and C1 are numeric cells. Cell C1 contains the formula A1 + B1. If the user changes cell A1, two Change events will occur, one for cell A1 and the other for cell C1.
Use the Text or Value property to retrieve the text in the changed cell. If the user changes a cell, the Change event is sent when the user leaves the cell.
Note that the Change event does not occur if the application changes the contents of a cell.
Use the SheetSendingEvent property if you want to return the sheet for which this event occured.
See Also
SheetSendingEvent, Text, Value properties