Knowledge Base

Help button is missing in VBA macro message box in Office for Mac

Article ID: 205191

Article Last Modified on 1/23/2007

APPLIES TO

This article was previously published under Q205191

SYMPTOMS

If you run Microsoft Visual Basic for Applications (VBA) code by using the MsgBox function with code to display a Help button, the button does not appear in the message box.

CAUSE

The "MsgBox Function" Help topic in Visual Basic for Applications Help is incorrect. It includes a reference to a vbMsgBoxHelpButton constant. This constant is available in Microsoft Office 97 and Microsoft Office 2000 programs for Windows, but there is no Help button available by using MsgBox in Microsoft Office programs for the Macintosh.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

If you add the vbMsgBoxHelpButton constant to the "Style" line, as given in the example in the Help topic "MsgBox Function", and then you run the code, the code does not produce a Help button in the Office programs that are listed at the beginning of this article. You can use the code in macros for both Windows and Macintosh Office programs without error, but the Help button only appears in Office for Windows programs. For additional information about how to use the vbMsgBoxHelpButton constant in Excel 97 and Excel 2000 for Windows, click the article number below to view the article in the Microsoft Knowledge Base:

164500 XL97: Help Argument for MsgBox Function Behaves Differently


Additional query words: XL97 mac XL2001KB vba Word Excel PowerPoint MacXLX XLX MacOFFX OFFX helpless aid assistance does not compute automate visual basic real

Keywords: kbpending kbprb KB205191


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.