beautypg.com

Juniper Systems Allegro DOS Manual User Manual

Page 149

background image

Windows CE Page 4-83

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()

All arguments are optional. Paste() function without arguments works
as Edit/Paste menu command. The Paste() function with arguments
works as Edit/Paste Special menu comment. The Default values for
arguments are Paste(true, true, false, false).
Example for paste contents, preserve previous format:

Paste(true, false)

PlaySound([filename])
Plays a sound (file of type *.wav). If you use this function without
parameter, any currently playing sound is stopped.
Example: PlaySound(“Song1.wav”)

RangeRef(col1, row1, col2, row2 [, sheetIndex])
Returns the range reference.
Example: MsgBox(Sum(RangeRef(a1,2,20,2)))

Return()
Stops task execution.
Example: if a1=0

MsgBox("A1 must not be 0")
Return()
end

RowHeight([height])
Returns row height of the first row of current selection and sets height
of selected rows if height is specified.
Example: Sel(A2:A7)

RowHeight(10)