Occurs when a cell first enters edit mode by typing a character.
Syntax
Private Sub object_ColEdit([ index As Integer,] ByVal colindex As Integer)
The ColEdit event syntax has these parts:
| Part | Description |
| object | An object expression that evaluates to an object in the Applies To list. |
| Index | An integer that identifies a control if it is in a control array. |
| colindex | An integer that identifies the column being edited. |
Remarks
If a floating editor marquee is not in use, this event also occurs when the user clicks the current cell or double clicks another cell.
The ColEdit event immediately follows the BeforeColEdit event only when the latter is not canceled.
When the user completes editing within a grid cell, as when tabbing to another column in the same row, pressing the ENTER key, or clicking on another cell, the BeforeColUpdate and AfterColUpdate events are executed if the data has been changed. The AfterColEdit event is then fired to indicate that editing is completed.