Page 406 - Excel for Scientists and Engineers: Numerical Methods

APPENDIX 1 SELECTED VISUAL BASIC KEYWORDS 383

Stop Command
Stops execution, but does not close files or clear variables.
See also: End
Str Function
Converts a number to a string.
Syntax: Str(numbefj
A leading space is reserved for the sign of the number; if the number is positive,
the string will contain a leading space.
See also: Format

String Data Type
Use to declare a variable's type as String, either in a Dim statement, or in a Sub or
Function statement. One bytekharacter required per variable.
Example: Dim J As Integer
See also: Dim, As, Boolean, Double, String, Variant

Sub Keyword
Marks the beginning of a Sub procedure.
Syntax: Sub name (argument?, ...)
Name is the name of the procedure. Argument?, etc., are the names assigned to the
arguments passed from the caller to the procedure. The end of the procedure is
delineated by End Sub
Example: See examples of Sub procedures in Chapter 2.
See also: Call, Function
Tan Function
Returns the tangent of an angle.
Syn tax: Tan (numbefj
Number is the angle in radians; it can be in the range 4 to +a To convert an angle
in degrees to one in radians, multiply by d180. Returns a value between -m and
+a.
See also: Atn, Cos, Sin

Text Property
Returns or sets the text associated with an object.
The text can be associated with a chart, button, textbox, control or range. For all
except range, this property is read-write, but for a range, it is read-only.
Example: Worksheets("Sheet1 ").Buttons( 1 ).Text = "Undo"
See also: Formula, Value

Trim Function
Returns a string without leading or trailing spaces.
Syntax: Trim(string)
See also: LTrim, RTrim