#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default VBA Help

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default VBA Help


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 :

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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default VBA Help

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

"keepITcool" ha scritto nel messaggio
ft.com...

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 :

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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default VBA Help


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 :

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

"keepITcool" ha scritto nel messaggio
ft.com...

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 :

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"