?
Solved

Excel VBA - Message Box with a help file

Posted on 2013-11-24
4
Medium Priority
?
1,113 Views
Last Modified: 2013-11-25
Hi:
I'm trying to get the following help file to work with my message box.  Don't know what I'm doing wrong.

MsgBox "msg", vbMsgBoxHelpButton, "title msg", "c:\student1\myhelpfile.chm"
0
Comment
Question by:brothertruffle880
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39673407
Try

MsgBox prompt:="msg", Buttons:=vbMsgBoxHelpButton, Title:="title msg", HelpFile:="c:\student1\myhelpfile.chm"
0
 

Author Comment

by:brothertruffle880
ID: 39673458
Hi  ssaqibh:

I tried running it and received the following message:
err
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 2000 total points
ID: 39673513
A context number is also required

MsgBox prompt:="msg", Buttons:=vbMsgBoxHelpButton, Title:="title msg", HelpFile:="c:\student1\myhelpfile.chm", Context:=1000
0
 

Author Closing Comment

by:brothertruffle880
ID: 39674010
Thank you.  Perfect!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question