How to create a help file

[rob nobel]

Could someone please tell me the best way to create a help file that can be
used in a VBA procedure within a msgbox or inputBox?
I don't know how to begin this process at all so full instructions would be
great.
Thank you,
Rob

 

[Dave Peterson]

If you're not interested in becoming an HTML/CHM author, you may want to look at
John Walkenbach's technique.

http://j-walk.com/ss/excel/tips/tip51.htm

(Remember that the only person who actually reads the help is the author <vbg>.)

 

[rob nobel]

Ahah, a wise guy, eh!
I thought the actual purpose of the helps is for someone to direct you there
AFTER everything else has been tried.
But thanks for the link. I thought if I saved the file with an .HLP
extension and put the path into the procedure that it should be called and
able to be viewed.....BUT NO! I guess I was too naive to think that that
could work.
AND I did look for help on this in VBA Help and could not find any. That,
of course doesn't mean anything, as I have often been directed to a Help
that I couldn't find for myself. Oh for a help that helps!
Rob

 

[Pete Lees]

Rob,

Could someone please tell me the best way to create a help file that can be
used in a VBA procedure within a msgbox or inputBox?

If you want to create a help file in WinHelp (.hlp) or HTML Help
(.chm) format then this page should get you started:

http://helpware.net/htmlhelp/basics.htm

For information on how to connect a WinHelp or HTML Help file to an
Office application, you could try:

"HelpAPI VBA module"
http://www.helpfulsolutions.com

"Adding Help to Your Custom Solution"
http://www.microsoft.com/technet/prodtechnol/office/office2000/proddocs/opg/part2/ch13.asp

"How to Create Custom Help Content"
http://www.microsoft.com/office/ork/2000/three/55t3_2.htm

 

[rob nobel]

Thanks for those links Pete. They should help out quite nicely.
Rob