Home > Language Reference > Classes > Grid

Change Event

Event raised when the contents of cell is modified by the user.

Syntax

Public Event Change(ByVal iRow As Integer, ByVal iCol As Integer, ByVal lItemData As Long, ByVal vNewValue As Variant)

Remarks

The Change event is raised each time the user modifies a value in a cell.

The iRow parameter contains the row index. This parameter is in the range 0 to Rows -1.

The iCol parameter contains the column index. This parameter is in the range 0 to the number of columns -1 (see Columns).

The lItemData parameter contains the value associated with the row. This value of type Long is is associated with the row when calling the AddItem or ItemData methods.

ThevNewValue parameter is a Variant which contains the new value of a cell.

The types of columns that can be edited are 'Text', 'Text with note', 'CheckBox' and 'Popup'.

For columns of type 'Text' or 'Text with note', the Change event is raised if a change occurs in the edit zone and uniquely when another cell becomes active. This implies that a PenDown event is raised for the new cell before the Change event is actually raised for the 'Text' or 'Text with note' zone which has been modified.

For columns of type 'Popup', the Change event is raised when the user chooses an item in the popup list whose index is different from its original value.

System requirements