Page 278 - Excel Data Analysis

15 537547 AppC.qxd 3/4/03 11:56 AM Page 264

APPENDIX

VBA AND EXCEL EVENTS QUICK REFERENCE

(CONTINUED)

VBA FUNCTION QUICK REFERENCE (CONTINUED)

Interaction Functions
FUNCTION DESCRIPTION RESULTS
Choose(index, choice-1[, choice-2, ...]) Selects and returns a value from a list of arguments. Mixed
DoEvents() Yields execution so the operating system can process Integer
other events.
IIf(expr, truepart, falsepart) Evaluates the expression and returns either the Mixed
truepart or falsepart parameter value.
InputBox(prompt[, title[, default[, Displays a dialog box prompting the user for input. String
xpos[, ypos[, helpfile, context]]]]])
GetAllSettings(appname, section) Returns a list of key settings and their values from the Variant
Windows Registry.
GetObject([pathname][, class]) Returns a reference to an object provided by an Variant
ActiveX Component.
GetSetting(appname, section, key[, Returns a key setting value from an application's entry Variant
default]) in the Windows registry.
MsgBox(prompt[, buttons[, title[, Displays a message box and returns a value representing Integer
helpfile, context]]]) the button pressed by the user.
Partition(number, start, stop, interval) Indicates where a number occurs within a series String
of ranges.
QBColor(color) Returns the RGB color code for the specified color. Long
Switch(expr-1, value-1[, expr-2, value-2 ...]) Evaluates a list of expressions and returns a value Variant
associated with the first True expression.
RGB(red, green, blue) Returns a number representing the RGB color value. Long
Mathematical Functions
FUNCTION DESCRIPTION RESULTS
Abs(number) Returns the absolute value of a number. Mixed
Atn(number) Returns the arctangent of a number. Double
Cos(number) Returns the cosine of an angle. Double

264