SSpread.ComboCloseUp Event
Occurs when the drop-down list of combo box cells is closed.
The following child objects are attached to the Event object.
| Type | Name | Description |
|---|---|---|
| Number | Col | Combo box cell column number |
| Number | Row | Row number of combo box type cell |
| Number | SelChange | Index of items selected when closed -1 if the same item as last time was selected |
The timing of the occurrence of this event and the determination of the cell value are different. The Change event is fired when the cell value change is confirmed, and the EditModeOff event is fired when the cell editing is complete.
SelChange is set to the item that was selected when it was closed, not the confirmed item. Even if you cancel with the ESC key, the item selected at that time will be set.
Check the selected value in the Change and EditModeOff events.
Example of usage
Function OnComboCloseUp(e) {
if (e.SelChange >= 0) {
Col = e.Col;
Row = e.Row;
TypeComboBoxIndex = e.SelChange;
MessageBox(TypeComboBoxString + "が選択されました");
}
}
Related Item
CellType property
Change, ComboDropDown, ComboSelChange, EditModeOff event