a UserForm.FIGURE 17-6: CommandButton controls.FIGURE 17-7: An Image control displays a photo.FIGURE 17-8: Label controls can take on many different looks.FIGURE 17-9: ListBox controls.FIGURE 17-10: Use a MultiPage control to create a tabbed dialog box.FIGURE 17-11: Two sets of OptionButton controls, each contained in a Frame cont...FIGURE 17-12: Two RefEdit controls.FIGURE 17-13: A ScrollBar control with a Label control below it.FIGURE 17-14: SpinButton controls.FIGURE 17-15: TextBox controls.FIGURE 17-16: ToggleButton controls.FIGURE 17-17: Choose Format ⇒ Align to change the alignment of UserForm con...FIGURE 17-18: The Tab Order dialog box.FIGURE 17-19: Use labels to provide direct access to controls that don’t have a...17 Chapter 18FIGURE 18-1: This dialog box logs dinner choices for guests.FIGURE 18-2: Executing the LogDinnerGuest procedure displays the dialog box.FIGURE 18-3: Use the custom dialog box for data entry.FIGURE 18-4: Determining which item in a list box is selected.FIGURE 18-5: Determining the selected items in a list box that allows multiple ...FIGURE 18-6: This dialog box lets the user select a range.FIGURE 18-7: This dialog box contains three sets of OptionButton controls.FIGURE 18-8: A UserForm with a spin button and a companion text box.FIGURE 18-9: This UserForm functions as a progress 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
