Spread 8.0 Documentation
Change Event
Support Options
ActiveX Reference > ActiveX Events > Change Event

Glossary Item Box

Change Event


See Also

Applies To

fpSpread control

Description

Occurs when the user modifies the contents of a cell.

Syntax

C++

afx_msg void OnChangefpSpread(UINT, int, CWnd*, LPVOID);

Visual Basic

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.