Juniper-systems Allegro CX Manual Manuel d'utilisateur télécharger pdf (Page 171)

Allegro CX Owner’s Manual 171

Calling a Procedure

You can structure your code into more simple tasks and then you can

call previously deﬁ ned task from within a task using its name.

Example:

Set(a1,100)

while a1>0

Hello

Set(a1, a1-1)

end

Comments

Set(a1,100) ‘Note: set cell A1 to value 100

Automating Tasks Functions Reference

Parameters in [ ] are optional.

ActiveCell()

Returns the active (highlighted) cell.

Example:

Set(ActiveCell(), “Hello World!”)

ActiveSheet([index])

Returns the number of the active sheet (1-based) and selects the new

one if index is speciﬁ ed. Returns “!!Val” if index is less than 1 or

greater than number of sheets.

Example: ActiveSheet(2)

Beep([soundType ])

Plays a waveform sound. SoundType speciﬁ es the system sound

type (64 – asterisk, 48 – exclamation, 32 – question, 16 – hand, no

parameter – default sound).

Example:

Beep()

Beep(32)

CellRef(col, row [, sheetIndex])

Returns the cell reference.

Example:

Set(CellRef(a1,2), 123)

1 2 ... 166 167 168 169 170 171 172 173 174 175 176 ... 303 304

Pas de commentaire

Juniper-systems Allegro CX Manual Manuel d'utilisateur Page 171