Determine the row and column of the cursor

[hals_left]

Hi

How do I access the column and row number properties of:
selection.cells(1)

Also is there a way to create an event that fires when the user tabs out of a cell.

Thanks
hals_left

 

[Klaus Linke]

Hi hals_left,

How do I access the column and row number properties of:
selection.cells(1)

Check out the .Information property:

With Selection.Cells(1).Range
MsgBox .Information(wdStartOfRangeColumnNumber),,"Column"
MsgBox .Information(wdStartOfRangeRowNumber),,"Row"
End With

Also is there a way to create an event that fires when the user tabs out

of a cell.

Not strictly a kind of event handling, but you can intercept the built-in
command "NextCell" that runs whenever a user uses the tab key in a table:

Sub NextCell()
MsgBox "Running NextCell..."
WordBasic.NextCell
End Sub

Greetings,
Klaus

 

[Jezebel]

Apart from the Information function that Klaus suggests, the cell also has
ColumnIndex and RowIndex properties:

Selection.Cells(1).RowIndex, .ColumnIndex

The WindowSelectionChange event fires when the user tabs out of a cell.

 

[hals_left]

Thanks - just what I was after.

Apart from the Information function that Klaus suggests, the cell also has
ColumnIndex and RowIndex properties:

Selection.Cells(1).RowIndex, .ColumnIndex

The WindowSelectionChange event fires when the user tabs out of a cell.