Index_P


P

Page Down key, 77
Page object, 836
Page Setup dialog, 534
Page Up key, 77
PageFields() method, 717, 728
pagePreview constant, 608
PageRange property, 716, 728
Pages object, 837
PageSetup object, 331, 837
Pane objects, 218, 837
Panes object, 837
Panes.ActivePane method, 218
para8 parameter, 105
ParamArray keyword, 104
ParamArray parameter, 310, 316
parameter list, 99
definition of, 120
for DLL functions, 757-58
Parameter object, 649, 838
parameters
evaluation of parameter procedure code, 120
executing Open without additional, 650
matrices as, 102-3
named, 105-6
optional, 103
parameter list, 99, 120
and passing of fields, 100-102
passing to a dialog, 388-89
value and return parameters, 99-100
variable number of, 104
Parameters enumeration, 662
Parameters method, 668
Parameters object, 838
Parent method, 713
ParentFolder property, 273, 302
Password parameter, 651, 652
password protection, 75, 322-23
Paste Function form, 308
Paste method, 202, 228, 229
PasteFace method, 469
PasteSpecial method, 228, 230, 555
for copying print region of form, 515
for efficient processing, 363
pasting cells , 202, 228-30
Path property, 217, 272, 283, 302
pattern-matching , 239
percent (%) symbol, 198
Percent style, 197
Periods parameter, 718
personal macros, 335-36
Personal Macro Workbook, 61-62, 82
Personal.xls file, 140, 224
Phonetic(s) object, 838
Pi constant, 91
Picture object, 839
Picture property, 431
PictureFormat object, 560, 839
pictures, internal representation of, 854
pivot charts , 52, 529, 709-10
pivot fields, 61
pivot tables, 692-710
construction and reconstruction of, 716-20
example, 692-96
in Excel 2002, 50
for external data, 703-7
generating and deleting, 711-15
layout options, 697-703
and MS Query, 692
options for, 708-9
overview, 692
PivotCache method, 728
PivotCache object, 642, 839
PivotCache objects, 720-27
PivotCaches object, 840
PivotCell object, 840
PivotChart command, 710
pivot-chart worksheet, 710
PivotField object, 840
PivotFields() method, 728
PivotFields object, 840
PivotFormula object, 841
PivotFormulas object, 841
PivotItem object, 841
PivotItem objects, 718-19
PivotItemList object, 841
PivotItems object, 841
PivotLayout object, 536, 841-42
PivotLayout.PivotTable property, 725
PivotTable object, 716, 797, 842
PivotTable wizard, 693-94
PivotTableClose event, 50
PivotTableOpen event, 50
PivotTables object, 714, 842
PivotTableWizard method, 63
Placement property, 561
plot area, 530
PlotArea object, 535, 536, 537, 538, 842
Point object, 843
Points object, 536, 843
polymorphism, 468
Position property, 467, 483
positional information, 660
PowerTalk e-mail system, 737
Precision, field property, 668
predefined constants, 96
Prepare Microsoft Word Mail Merge button, 578, 592
Preserve keyword, 93
Print # command, 280
Print command, 240, 278, 299, 305
Print in black and white option, 534
Print method, 76, 81, 107, 299, 376, 386, 820
Print_Info procedure, 168
PrintAndSave procedure, 614, 615
Printed chart size option, 534
printing
charts, 534, 543-44
files, 145
invoice, in balance sheet example, 603, 614-15
options for, 326
PrintObject property, 504
PrintOut method, 543-44
in btnPrint_Click procedure, 524-25
in btnPrintAndSave_Click procedure, 514
Private functions, 108
Private keyword, 111
Private Sub/Function keyword, 112
Private Sub name line, 38
Private var keyword, 112
procedural programming, 97-122. See also parameters; procedures; variables
branching, 112-15
with IfThen, 121
with Select Case, 121
loops , 115-19
with DLLoop, 122
with ForNext, 122
overview, 97
syntax summary, 119-22
procedures, 97-107. See also names of specific procedures
call procedures, 105
calling, 104
creating with macro recorder, 513
data types of values returned by functions, 99
definition of, 77, 119, 121
displaying all belonging to entire module, 73
evaluation of parameter procedure code, 120
names of, 98
overview, 97-98
and passing of fields, 100-102
premature exiting of, 98
procedure call, 120
realm of validity of, 107-12
recursion, 106-7
stored, 814-15
procedures list, 374-75
ProcessIncomingFolder procedure, 675, 679, 684
ProcessSurveyFile procedure, 675-76
product list example, 628-30
Products table, 621, 624
program code
dates and times in, 248
editing QueryTable objects with, 641
program code window, cursor movement in, 77
program execution, 376
program interruption
with breakpoints, 377
for debugging, 375
for lengthy calculations, 360
limiting user ability to perform, 385-86
with watch expressions, 377-79
program units. See procedures
project explorer, 71
project properties, 75
Prompt parameter, 652
Prompt setting, 653
properties, 7, 123-24. See also names of specific properties
default, 125
distinguishing from methods , 125-27
in Excel 97, 57
in Excel 2000, 52
Excel-specific, 283-86, 303
whose names given as character strings, 129
PROPERTIES button, 638
Properties object, 843
properties window, 34, 71-72
Property Get procedure, 162
Property Let procedure, 162
Property object, 650
Property Set procedure, 162
Protect method, 49, 318, 320, 321, 326
ProtectContents property, 320
ProtectDrawingObjects property, 320
protection mechanisms
limitations, 317-18
new in Excel 2002, 321-22
permitting access to certain users, 323
for program code, 324-25
protecting cell ranges with passwords, 322-23
protecting cells from changes, 319-20
protecting entire worksheet, 321
restricting activity area, 319
restricting field of action, 318
for shared workbooks, 324
for toolbars , 326
worksheet, 515
Protection object, 49, 843
Protection property, 326, 478, 483
ProtectScenarios property, 320
ProtocolMenu_DailyProtocol procedure, 556
ProtocolMenu_GenerateNewFiles procedure, 556
ProtocolMenu_MonthlyProtocol procedure, 556
Provide parameter, 652
Provider keyword, 653
Provider parameter, 647, 651
PtCompare function, 725
ptLayout field, 725, 726
Public keyword, 108, 110, 161
public variables, 108, 608
Public var keyword, 112
PublicNonCreatable, 164
Publish As Web Page dialog, 740-41
Publish method, 744
PublishingYear property, 169
PublishObject (Export) object, 53
PublishObject object, 743-44, 844
PublishObjects object, 844
Put command, 278, 282, 283, 305
PutInClipboard method, 230
PWD keyword, 653



Definitive Guide to Excel VBA
Linux Application Development For The Enterprise (Charles River Media Programming)
ISBN: 1584502533
EAN: 2147483647
Year: 2002
Pages: 134

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net