UserFormulaEntered Event
Applies To
fpSpread control
Description
Occurs when the user types a formula.
Syntax
C++
afx_msg void OnUserFormulaEnteredfpSpread(UINT, int, CWnd*, LPVOID);
Visual Basic
Sub fpSpread_UserFormulaEntered(ByVal Col As Long, ByVal Row As Long)
Parameters
The following parameters are available:
Parameter | Description |
---|---|
Col | Column number of cell containing formula |
Row | Row number of cell containing formula |
Remarks
The application can access the formula using the Formula property.
Use the SheetSendingEvent property if you want to return the sheet for which this event occured.
See Also
AllowUserFormulas, Formula, SheetSendingEvent properties