User Manual

Page 4-136 Windows CE
InsertCells(colsRows)
Inserts cells (true - columns, false - rows).
Example: InsertCells(false)
LastCol([rowNumber] )
Returns the last nonblank cell in the whole sheet (if rowNumber is
not specified) or in the specified row.
Example: last = LastCol()
last = LastCol(15)
LastRow([columnNumber])
Returns the last nonblank cell in the whole sheet (if columnNumber is
not specified) or in the specified column.
Example: last = LastRow()
last = LastRow(15)
ListBox(title, range)
Shows list box dialog with items from range and with the title and
returns the index of the selected item.
Example: med = ListBox("Choose medicine",
Medicines!a1:a50)
ListBox2(title, item, item2, item3... item29)
Shows list box dialog with items: item1, item2, item3... and with the
title and returns the text of the selected item.
Example: car = ListBox("Choose car",
“BMW”, “Jaguar”, “Ferrari”)
Modified([onOff])
Returns true if the Modified flag is true (workbook was modified) and
sets the Modified flag to onOff (true or false).
Example: Modified(false)
MsgBox(text)
Shows the Message Box with the text.
Example: MsgBox("Hello")
Paste([contents, format, skipBlanks, onlyResults])
Pastes the clipboard to the current selection.
Example: Sel(A1:A5)
Copy()
Sel(B1)
Paste()