SSpread.Advance Event

Occurs when trying to move focus out of the spreadsheet area with the Tab or Direction keys.

Specifically, an event occurs during the following operations.

Press the Tab key in the last cell
Press Shift + Tab in the first cell
Press the bottom of the direction key on the last line
Press the top of the direction key on the first line

The following child objects are attached to the Event object.

Type	Name	Description
Number	*AdvanceNext*	$TRUE under the Tab or Arrow keys $FALSE above Shift + Tab or arrow keys

Operations with the Tab key will only fire if the ProcessTab property is $TRUE.

Example of usage

ProcessTab = $TRUE;
Function OnAdvance(e) {
    if (e.AdvanceNext == $TRUE) {
        MoveFocus($NEXTFOCUS);
    } else {
        MoveFocus($PREVFOCUS);
    }
}