Microsoft KB Archive/89183

{|
 * width="100%"|

Excel: Keyboard Shortcut Key Does Not Appear Correctly

 * }

-

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 &quot;n&quot; 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: