Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 205191 - Last Review: January 23, 2007 - Revision: 3.4
Help button is missing in VBA macro message box in Office for Mac
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=164500/EN-US/
)
XL97: Help Argument for MsgBox Function Behaves Differently
APPLIES TO
- Microsoft Excel 2004 for Mac
- Microsoft PowerPoint 2004 for Mac
- Microsoft Word 2004 for Mac
- Microsoft Excel X for Mac
- Microsoft PowerPoint X for Mac
- Microsoft Word X for Mac
- Microsoft Excel 2001 for Mac
- Microsoft PowerPoint 2001 for Mac
- Microsoft Word 2001 for Mac
- Microsoft Excel 98 for Macintosh
- Microsoft PowerPoint 98 for Macintosh
- Microsoft Word 98 for Macintosh
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please