TopLeftChange Event
Applies To
fpSpread control
Description
Occurs when the displayed left column or top row changes.
Syntax
C++
afx_msg void OnTopLeftChangefpSpread(UINT, int, CWnd*, LPVOID);
Visual Basic
Sub fpSpread_TopLeftChange(ByVal OldLeft As Long, ByVal OldTop As Long, ByVal NewLeft As Long, ByVal NewTop As Long)
Parameters
The following parameters are available:
| Parameter | Description |
|---|---|
| OldLeft | Column number of previous left column |
| OldTop | Row number of previous top row |
| NewLeft | Column number of new left column (If the value of OldLeft equals the value of NewLeft, the sheet did not scroll horizontally.) |
| NewTop | Row number of new top row (If the value of OldTop equals the value of NewTop, the sheet did not scroll vertically.) |
Remarks
The TopLeftChange event occurs when you change the displayed leftmost column or topmost row using the LeftCol or TopRow properties or when the user scrolls through the sheet using the keyboard or the scroll bars.
Use the SheetSendingEvent property if you want to return the sheet for which this event occured.
See Also
LeftCol, SheetSendingEvent, TopRow properties