User Manual

Table Of Contents
Windows CE Page 4-139
Automating Task Examples
Selecting cells from a2 to the last cell
Sel(RangeRef(1, 2, LastCol(), LastRow())
Selecting column by tapping the cell in the first row (onTap:
$A$1:$A$255)
curCol = Column(ActiveCell())
Sel(RangeRef(curCol, 1, curCol, LastRow())
Entering a product name to the tapped cell in column B from product
table in Sheet2 (onTap:$B$1:$B$16384)
choice = ListBox("Select a product", Sheet2!a1:a16384)
Set(ActiveCell(), CellRef(1, choice, 2))
Get current selection coordinates:
col = Col(Sel())
row = Row(Sel())
numCols = Cols(Sel())
numRows = Rows(Sel())
Keyboard Shortcuts
Format Cells Ctrl+1 Fill Right Ctrl+R
Select All Ctrl+A File Save Ctrl+S
Copy Ctrl+C Paste Ctrl+V
Fill Down Ctrl+D Close Ctrl+W
Find Ctrl+F Cu t Ctrl+X
Goto Ctrl+G Redo Ctrl+Y
Replace Ctrl+H Undo Ctrl+Z
File New Ctrl+N Clear Contents De l
File Open Ctrl+O