XL97: DocErr: vbMsgBoxHelpButton Not Listed in Help (164920)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
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

Modification Type:MinorLast Reviewed:10/12/2005
Keywords:kbprb KB164920
©2004 Microsoft Corporation. All rights reserved.