I'm using Excel 2007 and I am trying to assign Help to the various controls.
I've built the help file(CHM) and have used the following to test it:

Application.Help FilePathandName, ContextID

everything displays fine.

However, for CommandButton1, I've set its HelpContextID and set the form's
WhatsThisButton and WhatsThisHelp to True and things still don't seem to
work. The Help button comes out in the Title bar and the Question mark comes
out with the cursor when the Help button is clicked. However, nothing
happens when I click on CommandButton1. How do you let it know which Help
file you want to use?

Thanks for any thoughts,

Mike

Thoughts from the xl97 help file (better, faster, stronger) ...

"The topic identified by the HelpContextID property is available to users when a form is running. To display the topic, the user
must either select the control or set focus to the control, and then press F1."
Copyright(c) 1996 Microsoft Corporation.
--
Jim Cone
Portland, Oregon USA




"Mike"
wrote in message
I'm using Excel 2007 and I am trying to assign Help to the various controls.
I've built the help file(CHM) and have used the following to test it:

Application.Help FilePathandName, ContextID

everything displays fine.
However, for CommandButton1, I've set its HelpContextID and set the form's
WhatsThisButton and WhatsThisHelp to True and things still don't seem to
work. The Help button comes out in the Title bar and the Question mark comes
out with the cursor when the Help button is clicked. However, nothing
happens when I click on CommandButton1. How do you let it know which Help
file you want to use?
Thanks for any thoughts,
Mike

Also, a listing of Help ID's is available for download here...
http://www.rondebruin.nl/id.htm
--
Jim Cone
Portland, Oregon USA

The link info is for pulling out Excel help.

I have built my own help file which I have assigned contextIds for all the
controls in my application. Now, by using the forms "WhatsThisButton" and
"WhatsThisHelp" properties, I want to click on the HELP BUTTON in the title
bar and then click on one of my controls to bring out the help fo my
control. The problem is that I don't know how to tell the application where
my CHM file is. Application.Help(File,ID) doesn't do the job.



"Jim Cone" wrote in message
...
Also, a listing of Help ID's is available for download here...
http://www.rondebruin.nl/id.htm
--
Jim Cone
Portland, Oregon USA

Did you include the file path when you entered the file name?
If the .chm file is in the same folder as the workbook then...

Application.Help ThisWorkbook.Path & "\FileName.chm", 1234
--
Jim Cone
Portland, Oregon USA



"Mike"
wrote in message
The link info is for pulling out Excel help.
I have built my own help file which I have assigned contextIds for all the
controls in my application. Now, by using the forms "WhatsThisButton" and
"WhatsThisHelp" properties, I want to click on the HELP BUTTON in the title
bar and then click on one of my controls to bring out the help fo my
control. The problem is that I don't know how to tell the application where
my CHM file is. Application.Help(File,ID) doesn't do the job.



"Jim Cone" wrote in message
...
Also, a listing of Help ID's is available for download here...
http://www.rondebruin.nl/id.htm
--
Jim Cone
Portland, Oregon USA

Application.Help will display my help file IMMEDIATELY, NOT when I cl;ick on
the desired control after clicking the "WhatsThis" HELP button in the Title
bar.


"Jim Cone" wrote in message
...
Did you include the file path when you entered the file name?
If the .chm file is in the same folder as the workbook then...

Application.Help ThisWorkbook.Path & "\FileName.chm", 1234
--
Jim Cone
Portland, Oregon USA



"Mike"
wrote in message
The link info is for pulling out Excel help.
I have built my own help file which I have assigned contextIds for all the
controls in my application. Now, by using the forms "WhatsThisButton" and
"WhatsThisHelp" properties, I want to click on the HELP BUTTON in the
title
bar and then click on one of my controls to bring out the help fo my
control. The problem is that I don't know how to tell the application
where
my CHM file is. Application.Help(File,ID) doesn't do the job.



"Jim Cone" wrote in message
...
Also, a listing of Help ID's is available for download here...
http://www.rondebruin.nl/id.htm
--
Jim Cone
Portland, Oregon USA

It appears what you trying to do will Not work with .chm files only with .hlp files.
You can specify the .hlp file in the Initialize event of the form...
.... Application.ThisWorkbook.VBProject.HelpFile = "xxxx.HLP"
and the WhatsThis? feature will work to a degree.
It may be simpler and easier to add a "help" button on the form which opens your file.
--
Jim Cone
Portland, Oregon USA



"Mike"
wrote in message
Application.Help will display my help file IMMEDIATELY, NOT when I cl;ick on
the desired control after clicking the "WhatsThis" HELP button in the Title
bar.