Syntax
PrevCell
PrevCell()
Remarks
The PrevCell statement selects the contents of the previous cell (the same as pressing SHIFT+TAB in a table). If there is already a selection including multiple cells, PrevCell selects the first cell in the selection.
The PrevCell() function behaves the same as the statement and also returns the following values.
Value | Explanation | |
0 (zero) | If the selection is wholly contained in the leftmost cell of the first row (in other words, if the selection is not moved) | |
–1 | If the selection is moved |
Example
This example moves the selection to the previous cell; if the selection is in the first cell, the entire table is selected.
If PrevCell() = 0 Then TableSelectTable
See Also
NextCell