VBA Help

A

Andrea

Hi,
i want to extend the VBA help (.hlp) file with some word, for example I made
a routine "MyRoutine" and I would like to make the help window of this new
topic appear when I push F1. I don't know if it is possible!
Anyone can help me?
ThankYou!
->Andrea
 
K

keepITcool

yep.
create a WinHelp (.hlp) file with
(free) HelpMaker
http://www.vizacc.com/gen_download.php

or (not free but possible a bit easier to use)
HelpScribble from http://www.helpscribble.com/

btw: plenty of other help authoring tools out there
(you could do without and just type your own RTF file.)
help compilers (WinHelp and HTMLhelp) available from microsoft.
most tools can compile to a variety of help systems.


add some content make sure you map the context IDs.
read: http://www.helpscribble.com/winhelp.html
and : http://www.helpscribble.com/vba.html



then type the path to the .hlp file
via VBE Project Properties.

add HelpContextID to your controls or functions
(function helpID via object browser)


for context help .HLP is easier.
for just F1 help you may want to use html help (.CHM)





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Andrea wrote :
 
A

Andrea

Thank you very much, I've tried to store some the HelpID with the object
browser but when I press OK and reopen the property of a function the HelpID
is always 0!
->Andrea
 
K

keepITcool

first create the .hlp file
(note or print the valid TopicID's)

then add path to .hlp in VBA Project Properties

If the entered helpID is valid it should be saved.

If you have problems with changing the help ID
force recompile of the module by changing
a constant or a function name.

After that your changes are stored again.. :)



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Andrea wrote :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top