Help file in excel

[HorseGoose]

I have almost finished a program which helps beverage developers make soft drinks. I have created a help file using Help and Manual 3.3

I cannot make it so when the user pushes F1 the file automatically loads. instead the normal excel help window loads.

I tried using the application.help = "\helpfile.chm" this works but doesn't load up the right GUI so the search functions and indexes are blank. Can anyone help me here?

 

[Luis939]

maybe this example could help but you would have to go through a msgbox

Dim Msg, Style, Title, Help, Ctxt, Response, MyString
Msg = "Help File" ' Define message.
Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons.
Title = "MsgBox Demonstration" ' Define title.
Help = "DEMO.HLP" ' Define Help file.
Ctxt = 1000 ' Define topic
' context.
' Display message.
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
If Response = vbYes Then ' User chose Yes.
MyString = "Yes" ' Perform some action.
Else ' User chose No.
MyString = "No" ' Perform some action.
End If

Hopefully maybe then you could link up to your help file