Juniper-systems Allegro CX Manual Manual do Utilizador descarregar pdf (Página 180)

180 Allegro CX Owner’s Manual

TopLeftCell(reference)

Returns the top left cell on the screen and sets it if reference is

speciﬁ ed.

Example:

TopLeftCell(A1)

WorkbookName()

Returns name of the opened workbook.

Example:

Save(WorkbookName())

YesNoBox(text)

Shows the box giving the choice yes or no and returns true if user

selects Yes.

Example:

if YesNoBox(“Stop”) then

Return()

end

Zoom([magniﬁ cation])

Returns current value of zoom magniﬁ cation and sets it to

magniﬁ cation if speciﬁ ed.

Example:

Zoom(65)

Zoom(Zoom()-10)

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 ﬁ rst 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))

1 2 ... 175 176 177 178 179 180 181 182 183 184 185 ... 303 304

Sem comentários

Juniper-systems Allegro CX Manual Manual do Utilizador Página 180