1003
Index
overview, 795–796
ranges
copying, 888–889
copying variable-size, 889
counting selected cells, 895–896
determining type of selections, 893–894
identifying multiple selections, 895
looping through, 891–893
moving, 891
overview, 887–888
prompting for cell values, 893
selecting rows or columns, 890–891
selecting to end of rows or columns, 890
recording
absolute versus relative, 808–809
assigning to buttons, 810–811
assigning to shortcut keys, 810
basics, 802–803
editing, 805
examining, 804–807
example of, 803, 806
re-recording, 807–808
running, 806
storing in Personal Macro Workbook, 809–810
testing, 805, 808
saving with .xlsx file extension, 148
saving workbooks
all, 896
closing and, 896–897
containing macros, 798
security, 797–798
speed tips
declaring variable types, 901–902
preventing alert messages, 900
simplifying object references, 900–901
turning off screen updating, 899
Sub procedures, 799–800
writing VBA code
entering and editing, 812
event-handler procedures, 874–875
For-Next loops, 818
how VBA works, 812–814
If-Then construct, 818
macro that can’t be recorded, 819–821
methods, 817
objects and collections, 814–815
overview, 811
properties, 815–817
Select Case construct, 819
variables, 817
With-End With construct, 818–819vbDefaultButton2 constant, MsgBox function, 841
vbDefaultButton3 constant, MsgBox function, 841
VBE (Visual Basic Editor). See Visual Basic Editor (VBE)
VBExclamation constant, MsgBox function, 841
vbInformation constant, MsgBox function, 841
vbOKCancel constant, MsgBox function, 840
vbOKOnly constant, MsgBox function, 840
vbQuestion constant, MsgBox function, 841
vbRetryCancel constant, MsgBox function, 841
vbYesNo constant, MsgBox function, 840
vbYesNoCancel constant, MsgBox function, 840
VDB function, 351, 924
vector-based image, 531
Versions section, Info options, 149, 156
vertical alignment options, worksheet, 124
vertical page break, 181–182
vertical scrollbar, 6, 8
Veterans Day, date functions, 270
View tab, Ribbon, 549
views
chart data, 411
page
Normal view, 173–174
overview, 172–173
Page Break Preview mode, 175–176
Page Layout view, 174–175
templates, 161–162
worksheets
freezing panes, 62–64
multiple windows, 60–61
overview, 58
side by side sheets, 61
splitting window into panes, 62
Watch Window, 64–65
zooming, 59–60
Visible Cells Only option, Go to Special dialog box, 76
visible digital signature, 647
Visible property, 864
Visual Basic Editor (VBE)
creating macros for controls, 864–865
defined, 801
disabling Mini toolbar, 118
Project window, 804
sizing and aligning controls, 852
window, 798
Visual Basic for Applications (VBA) functions, 800–801, 823
Visual Basic for Applications (VBA) macros
charts
applying formatting, 899
modifying properties, 898
modifying type, 898
displaying Developer tab, 796–79760_474877-bindex.indd 100360_474877-bindex.indd 1003 3/29/10 11:48 PM3/29/10 11:48 PM