Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to create a help file

0 views
Skip to first unread message

rob nobel

unread,
Dec 6, 2003, 9:20:15 PM12/6/03
to
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

unread,
Dec 7, 2003, 11:20:59 AM12/7/03
to
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>.)

--

Dave Peterson
ec3...@msn.com

rob nobel

unread,
Dec 7, 2003, 10:57:26 PM12/7/03
to
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

"Dave Peterson" <ec3...@msn.com> wrote in message
news:3FD3536B...@msn.com...

Pete Lees

unread,
Dec 8, 2003, 5:23:06 AM12/8/03
to
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

--
Pete (Microsoft Help MVP)

rob nobel

unread,
Dec 8, 2003, 6:58:24 PM12/8/03
to
Thanks for those links Pete. They should help out quite nicely.
Rob

"Pete Lees" <PD....@btinternet.com> wrote in message
news:c8bde505.03120...@posting.google.com...

0 new messages