M


/m switch, 75
Macro Control functions, category, 308
Macro dialog box, procedures, 241
macro recorder
absolute references, 159-162
charts and, 572-574
cleaning up recorded macros, 163-165
entering code and, 148-152
macro names , 162
recording, 158-159
relative references, 159-162
shortcut keys, 163
storing macros, 163
macro viruses, 939
macros
CommandButton, 119
disappearing , 931
introduction, 44
pausing for user data entry, 956
pausing for user-selected range, 324-326
preventing from showing list, 944
recording, 930, 937
running, 930
running at specified time, 944
SelectCurrentRegion, 320
ShowInstalledFonts, 351
sounds, 963
storing, 163
undoing, 956
XLM, 358-361
MakeForm procedure, 876-877
MakeList procedure, 293
MakeLoanTable procedure, 685-686
MakeMemos procedure, 682-683
MakePivotTables function, 566-568
MakeShapeWithGradient procedure, 920
MakeShapeWithPattern procedure, 921
MakeShapeWithPicture procedure, 922
MakeShapeWithText procedure, 924
MakeShapeWithTexture procedure, 923-924
manually entering code, 145-148
Margin Indicator Bar option (VBE), 156
Math & Trig functions, category, 308
mathematical operators, 942
MaxAllSheets function, 373-374
megaformulas , 30, 69-71
menus . See also shortcut menus
custom, 115
UserForms, 450-451
merged cells , 180
message boxes, line breaks, 948
Method or date member not found error, 992
methods
Activate, 319, 578
ActivateMicrosoftApp, 674-675
AddChart, 575-576, 576
AddComment, 177
AddDataField, 558
ApplyLayout, 589
Areas, 327
arguments, 169-170
ClearToMatchStyle, 589
Copy, 317
CreatePivotTable, 558, 562-563
Cut, 318
description, 169-170
Deselect, 580
End, 320
ExecuteMso, 734
executing, 982
FillDown, 333-334
FindControl, 765
GetEnabledMso, 734
GetImageMso, 734
GetLabelMso, 734
GetOpenFilename, 399-402
GetPressedMso, 734
GetSaveAsFilename, 403
GetScreentipMso, 734
GetSupertipMso, 734
Hide, 429
InputBox, 324-326, 392-393
introduction, 137
Move, 262
objects, 185, 894
Reset, 768
ResetAll, 769
Run, 244
SendKeys, 693-695
SetElement, 589
SetSourceData, 577
ShowDataForm, 411
SpecialCells, 258
Volatile, 288
MHTML files, Help system, 793-794
Microsoft Help 2, 794
Microsoft Office applications, activating, 674-675
Microsoft Office Compatibility Pack, 819
Microsoft Query, developers and, 13
Microsoft Technical Support
Excel home page, 972
Microsoft Knowledge Base, 972
Office home page, 972
support options, 972
Mid function, 985
Mid statement, 979
Minute function, 985
MIRR function, 985
MkDir command, 830
MkDir statement, 979
modal dialog boxes, 27, 488
modal message box, displaying, 985
modeless dialog boxes, 27, 488
modifying, add-ins, 708
Module1 VBA module, Text Tools utility
declarations, 540-541
ShowTextToolsDialog procedure, 541-542
UndoTextTools procedure, 542
modules. See also class modules
adding to projects, 143
deleting from projects, 143
introduction, 135
private, 980
replacing, 868-869
Text Tools workbook, 537
updating, 867-869
month as number, 985
month as string, 985
Month function, 985
MonthName function, 985
MonthNames function, 296
mouse, button
press while over chart, 603
release while over chart, 603
MouseDown event, 603, 654, 661
MouseMove event, 603, 654, 661
MouseOver event, displaying text and, 615-617
MouseUp event, 603, 654, 661
Move Chart dialog box, 578-579
Move method, 262
MoveChart function, 578-579
MoveDownButton_Click procedure, 471
MoveRange function, 318
MoveUpButton_Click procedure, 471
Mr. Excel Web site, 976
MsgBox function, 215-216, 394-399
multicolumn ListBox controls, 472-474
multidimensional arrays, declaring, 210-211
multilanguage applications, 823-824
MultiPage control
adding pages, 480
buttons , 480
progress indicator and, 496-499
properties, 480
RefEdit control, 453
selecting, 480
tabs, 480
TransitionEffect property, 480
UserForms, 418, 479-480
wizards, 500-501
MultiPlan, 8
MultiSelect property, 466-467
MyMsgBox code, 507-508
MyMsgBox function, 508-510
MySum function, 301-304



Excel 2007 Power Programming with VBA
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
ISBN: 0470044012
EAN: 2147483647
Year: 2007
Pages: 319

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