
Originally Posted by
Krool
Try the BeforeRowColChange event. That's for the caret.
There are also BeforeSelChange event.
thank you! I had only tried Before RowColChange, with your indication I understood better how to implement that operation.
that did the job.
Code:
Private Sub table1_BeforeRowColChange(ByVal NewRow As Long, ByVal NewCol As Long, Cancel As Boolean)
If NewCol = 2 Then
Cancel = True
table1.Col = 3
End If
End Sub
Private Sub table1_BeforeSelChange(ByVal NewRowSel As Long, ByVal NewColSel As Long, Cancel As Boolean)
If NewColSel = 2 Then
Cancel = True
End If
End Sub