The EventMode property specifies whether VBA grid events occur for the original or modified version of the grid.
grid.EventMode [= mode]
• grid – A grid object.
• mode – A constant specifying when events occur:
Constant |
Description |
---|---|
emOriginalOnly |
Grid events occur only for the original version of the grid. |
emModifiedOnly |
Grid events occur only for the modified version of the grid. |
emNever |
Grid events don’t occur for the grid. |
If you use the Modifier to modify a window containing a grid (such as a lookup window), VBA grid events will occur only if you set both the window’s and the grid’s EventMode property to emModifiedOnly. Changing this property allows events to occur only for the modified version of the window and the grid. To change the EventMode property for the window object, use the Visual Basic Properties window.
Windows modified using the Modifier include a period (.) at the beginning of the window’s caption. Windows that invoke VBA events include a period at the end of the window’s caption. Grids have no caption.