Excel: Keyboard Shortcut Key Does Not Appear Correctly
ID: Q89183
|
The information in this article applies to:
-
Microsoft Excel for Windows, versions 3.0, 4.0
-
Microsoft Excel for the Macintosh, versions 3.0, 4.0
SUMMARY
In a Microsoft Excel custom dialog box, a single text item (number 5)
can have multiple lines if an appropriate width and height is
specified for the item. However, in Microsoft Excel for Windows, using
an ampersand (&) to assign a keyboard shortcut for selecting the
associated edit box or list box will result in an underscore being
added not only to the first line, but to each subsequent line in the
text string. The underscore in the subsequent lines appears in the
same position as the underscore in the first line. Only the letter
underlined in the first line will activate the associated edit box or
list box.
In Microsoft Excel for the Macintosh, if a width and height is
specified for the text item, the underscore will not appear in either
a single line or multiple line text item when the dialog box is
displayed.
MORE INFORMATION
Using an ampersand to designate a keyboard shortcut will only work
correctly with single line text items. If you have multiple lines and
wish to use a keyboard shortcut, use a separate text item for each
line.
Example
- Enter the following into a macro sheet:
B1: C1: D1: E1: 320 F1: 144 G1: H1:
B2: 1 C2: 201 D2: 6 E2: 88 F2: G2: OK H2:
B3: 2 C3: 200 D3: 34 E3: 88 F3: G3: Cancel H3:
B4: 5 C4: 18 D4: 6 E4: 140 F4: 80 G4: Enter your
name, rank
and serial
number (on one
line)
B5: 6 C5: 18 D5: 68 E5: 160 F5: G5: H5:
- To display the custom dialog box, create the following macro:
A1: =DIALOG.BOX(B1:H5)
A2: =RETURN()
- Select cell A1. Choose Run from the Macro menu and then choose the
OK button.
The text item in the following dialog box definition table will result
in three lines of text. In Microsoft Excel for Windows, the second
letter of each line will be underlined; however, only the "n" in the
first line will activate the edit box. In Excel for the Macintosh, no
underscores will appear.
Breaking the multiple line text item into 3 single line text items as
in the following definition table will allow the underline to appear
normally.
B1: C1: D1: E1: 320 F1: 14 G1: H1:
B2: 1 C2: 201 D2: E2: 88 F2: G2: OK H2:
B3: 2 C3: 200 D3: 34 E3: 88 F3: G3: Cancel H3:
B4: 5 C4: 18 D4: 6 E4: F4: G4: Enter your name,
B5: 5 C5: 18 D5: 20 E5: F5: G5: rank and serial
B6: 5 C6: 18 D6: 34 E6: F6: G6: number
B7: 6 C7: 18 D7: 68 E7: 160 F7: G7: H7:
REFERENCES
"Microsoft Excel User's Guide 2," version 4.0, pages 263-280
Additional query words:
3.0
Keywords :
Version :
Platform :
Issue type :