ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Help (https://www.excelbanter.com/excel-programming/328622-vba-help.html)

Andrea[_9_]

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



keepITcool

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


Andrea[_9_]

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




keepITcool

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



All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com