Page 280 - Excel Data Analysis

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

APPENDIX

VBA AND EXCEL EVENTS QUICK REFERENCE

(CONTINUED)

VBA FUNCTION QUICK REFERENCE (CONTINUED)

String Manipulation Functions (Continued)
FUNCTION DESCRIPTION RESULTS
Spc(n) Positions output when printing to a file. String
Str(number) Returns a string representation of a number. String
StrComp(string1, string2[, compare]) Returns a value indicating the result of a string Integer
comparison.
StrConv(string, conversion, LCID) Converts a string to the specified format. String
String(number, character) Creates a string by repeating a character the String
specified number of times.
Tab[(n)] Positions output when printing to a file. String
Trim(string) Trims spaces from left and right of a string. String
UCase(string) Converts a string to uppercase. String

EXCEL EVENTS QUICK REFERENCE

Application Events
EVENT TYPE DESCRIPTION

NewWorkbook Occurs when Excel creates a new workbook.
SheetActivate Excel activates any sheet in any workbook.
SheetBeforeDoubleClick Event occurs before the user double-clicks any sheet with the mouse.
SheetBeforeRightClick Event occurs before the user clicks any sheet with the right
mouse button.
SheetCalculate Excel calculates any worksheet.
SheetChange Cells on a worksheet change either due to a user or an external link.

266