Page 400 - Excel for Scientists and Engineers: Numerical Methods

APPENDIX 1 SELECTED VISUAL BASIC KEYWORDS 377

Database, 6; Text, 7; Logical, 8; Information, 9; User Defined, 14; Engineering,
15.
Example: Application.MacroOptions rnacro:="FtoC", Description:= "Converts
Fahrenheit temperature to Celsius", Category:=3
provides a description for the macro FtoC and assigns it to the Math & Trig
category.

Mid Function
Returns the specified number of characters from a text string, beginning at the
specified position.
Syntax: Mid(string, start,numbefj
If start is greater than the number of characters in string, returns a null string. If
number is omitted, all characters from start to the end of the string are returned.
Example: Mid("H2S04",2,1) returns 2.
See also: Left, Len, Right

Mod Operator
Returns the remainder resulting from the division of two numbers.
Syntax: result = number1 Mod number2

MsgBox Function
Displays a message box.
Syntax: MsgBox(prompt,buftons, title, helpfile,context)
See Microsoft ExceWisual Basic Reference or On-Line Help for details.
See also: InputBox

Name Property
Returns or sets the name of an object.
Example: SeriesName = Selection.Name assigns the name of the selected chart
series to the variable SeriesName.
See also: NameLocal, Names

Next Keyword
Delineates the end of a For ... Next or For Each ... Next block of statements.
Not Operator
Logical operator. Performs logical negation: True becomes False, False becomes
True.
See also: And, Or

Now Function
Returns the current date and time.
Syntax: Now
See also: other date and time functions.