Excel VBA Programming For Dummies. Dick Kusleika
indicator for a lengthy macr...FIGURE 18-10: The progress-indicator UserForm.FIGURE 18-11: The three tabs of a MultiPage control.FIGURE 18-12: Displaying a chart in a UserForm.
18 Chapter 19FIGURE 19-1: The Customize Ribbon tab of the Excel Options dialog box.FIGURE 19-2: The View tab with a new group named Text To Speech.FIGURE 19-3: RibbonX code displayed in the Custom UI Editor.FIGURE 19-4: The VBA callback procedure that is executed by clicking the Ribbon...FIGURE 19-5: Proof that adding a new Ribbon command using XML is actually possi...FIGURE 19-6: A control on the Add-in tab isn’t flashy, but it gets the job done...FIGURE 19-7: The Cell shortcut menu showing a custom menu item: Change Case.
19 Chapter 20FIGURE 20-1: Using the Commission function in a worksheet.FIGURE 20-2: Using the Commission2 function, which takes two arguments.FIGURE 20-3: Using a custom function to sum only odd numbers.FIGURE 20-4: Using the ExtractElement function to return an element from a stri...FIGURE 20-5: Using the MonthNames function to return a 12-element array.FIGURE 20-6: Using a custom function to return a sorted range.FIGURE 20-7: By default, the Insert Function dialog box doesn’t provide a descr...FIGURE 20-8: The custom function now displays a description.FIGURE 20-9: By default, the Function Arguments dialog box displays Function ar...
20 Chapter 21FIGURE 21-1: The Add-Ins dialog box lists all the add-ins known to Excel.FIGURE 21-2: The UserForm for the Change Case add-in.FIGURE 21-3: Use the Properties section to enter descriptive information about ...FIGURE 21-4: The Add-Ins dialog box has the new add-in selected.FIGURE 21-5: Making an add-in not an add-in.
21 Chapter 22FIGURE 22-1: A single apostrophe in front of any line turns that line into a co...FIGURE 22-2: The Edit toolbar allows you to select entire blocks of code and ap...FIGURE 22-3: Holding down the Ctrl key while dragging code creates a copy of th...FIGURE 22-4: Pressing Shift+F2 with your cursor on a function or variable name ...FIGURE 22-5: Click the Procedure View button to show only the active procedure.FIGURE 22-6: Press F8 key to step through each line of your macro at your own p...FIGURE 22-7: You can click and drag the yellow arrow while stepping through you...FIGURE 22-8: A breakpoint is marked by a dot in the left margin along with shad...FIGURE 22-9: Showing the ending characters in a variable tooltip.FIGURE 22-10: Leaving an unfinished line of code, even for a second, results in...FIGURE 22-11: Uncheck the Auto Syntax Check option to prevent warning messages ...
Guide
1 Cover
4 Table of Contents
6 Index
Pages
1 i
2 ii
3 1
4 2
5 3
6 4
7 5
8 6
9 7
10 8
11 9
12 10
13 11
14 12
15 13
16 14
17 15
18 16
19 17
20 18
21 19
22 20
23 21
24 22
25 23
26 24
27 25
28 26
29 27
30 29
31 30
32 31
33 32
34 33
35 34
36 35
37 36
38 37
39 38
40 39
41 40
42 41
43 42
44 43