How do you specify the Help File to be used

[Mike]

I'm using Excel 2007 and I am trying to assign Help to the various controls.
I've built the help file 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

 

[Kenneth Hobson]

Is it a HLP or a CHM help file? If HLP, I am not sure what the problem
would be.

Private Sub CommandButton1_Click()
Application.Help "OTISAPP.HLP", 65527
End Sub

 

[Mike]

It is a CHM file.