>I can't believe that I can't figure this out, but how can I change the active cell within a grid based on a user keystroke.
>
>Specifically, I am using a grid for entering a lot of data. The user will press tab to move across a row, but when they press enter, I want to move down one row and back to the leftmost column.
>
>On key label just doesn;t seem to have access to activerow and activatecell.
>
>Thanks
For a grid that columns are not tampered with (ColumnOrders might change at runtime but no check here) this code would do what you want :
Lparameters nColIndex
If lastkey() = 13 and nColIndex # 1
With This
.ActivateCell(.relativerow+1,1)
.Columns(1).Setfocus()
Endwith
Endif
Cetin