KB164920 - XL97: DocErr: vbMsgBoxHelpButton Not Listed in Help

Article ID: 164920

Article Last Modified on 10/12/2005

Microsoft Excel 97 Standard Edition

This article was previously published under Q164920

SYMPTOMS

RESOLUTION

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that this article describes. Apply it only to systems that are experiencing this specific problem.

To resolve this problem, contact Microsoft Product Support Services to obtain the hotfix. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix should have the following file attributes or later:

   Date      Time    Version      Size    File name     Platform
   -------------------------------------------------------------

STATUS

Microsoft has confirmed that this is a problem in Windows 98.

MORE INFORMATION

Microsoft provides examples of Visual Basic for Applications procedures for illustration only, without warranty either expressed or implied, including, but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures in this article are provided 'as is' and Microsoft does not guarantee that they can be used in all situations. While Microsoft support professionals can help explain the functionality of a particular macro, they will not modify these examples to provide added functionality, nor will they help you construct macros to meet your specific needs. If you have limited programming experience, you may want to consult one of the Microsoft Solution Providers. Solution Providers offer a wide range of fee-based services, including creating custom macros. For more information about Microsoft Solution Providers, call Microsoft Customer Information Service at (800) 426-9400.

The MsgBox Help topic includes an example that is incorrect; the example does not use the vbMsgBoxHelpButton constant, which is required. To correct the example code in the Help topic, add the constant to the "Style" line of code as follows:

   Style = vbYesNo + vbCritical + vbDefaultButton2 + vbMsgBoxHelpButton

For more information about how to use the vbMsgBoxHelpButton constant, please see the following article in the Microsoft Knowledge Base:

164500 Help Argument for MsgBox Function Behaves Differently

Additional query words: XL97

Keywords: kbprb KB164920