Microsoft KB Archive/108329: Difference between revisions

From BetaArchive Wiki
m (Text replacement - """ to """)
m (Text replacement - "&" to "&")
 
Line 1: Line 1:
{|
{|
|width="100%"|
|width="100%"|
== XL5: Cannot Use & Character as Accelerator Key in Dialog Box ==
== XL5: Cannot Use & Character as Accelerator Key in Dialog Box ==
|}
|}


Line 20: Line 20:
== SUMMARY ==
== SUMMARY ==


In Microsoft Excel 5.0, because ampersand is used internally to mark the next character as the accelerator, it is not possible to use an ampersand (&) as an accelerator character.
In Microsoft Excel 5.0, because ampersand is used internally to mark the next character as the accelerator, it is not possible to use an ampersand (&) as an accelerator character.


<br />
<br />
Line 32: Line 32:
# From the Insert menu, choose Macro, and then choose Dialog.
# From the Insert menu, choose Macro, and then choose Dialog.
# On the dialog sheet, use the check box button on the Forms toolbar to draw a check box.
# On the dialog sheet, use the check box button on the Forms toolbar to draw a check box.
# Change the box text to '''"Test&amp;Bar"''' (without the quotation marks).
# Change the box text to '''"Test&Bar"''' (without the quotation marks).
# Select the check box
# Select the check box
# From the Format menu, choose Object
# From the Format menu, choose Object
# Make the accelerator key the ampersand (&amp;) character.
# Make the accelerator key the ampersand (&) character.
# To run the dialog box, choose Run Dialog from the Tools menu.
# To run the dialog box, choose Run Dialog from the Tools menu.


The letter B of Test&amp;Bar is accelerated instead of the &amp; character
The letter B of Test&Bar is accelerated instead of the & character


Additional query words: dialog box amphasize alt keyboard
Additional query words: dialog box amphasize alt keyboard

Latest revision as of 12:25, 21 July 2020

XL5: Cannot Use & Character as Accelerator Key in Dialog Box



The information in this article applies to:


  • Microsoft Excel for Windows, version 5.0





SUMMARY

In Microsoft Excel 5.0, because ampersand is used internally to mark the next character as the accelerator, it is not possible to use an ampersand (&) as an accelerator character.



MORE INFORMATION

Steps to Reproduce Behavior

  1. Start Microsoft Excel.
  2. From the Insert menu, choose Macro, and then choose Dialog.
  3. On the dialog sheet, use the check box button on the Forms toolbar to draw a check box.
  4. Change the box text to "Test&Bar" (without the quotation marks).
  5. Select the check box
  6. From the Format menu, choose Object
  7. Make the accelerator key the ampersand (&) character.
  8. To run the dialog box, choose Run Dialog from the Tools menu.

The letter B of Test&Bar is accelerated instead of the & character

Additional query words: dialog box amphasize alt keyboard

Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :
Technology :


Last Reviewed: April 9, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.