ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating a help file (https://www.excelbanter.com/excel-programming/330562-creating-help-file.html)

Yoam69

Creating a help file
 
Is it possible to create a simple help file in VB for excel without the use
of a developer tool kit?

Robin Hammond[_2_]

Creating a help file
 
Yes, but there are lots and lots of ways to do it. I eventually ended up
using this: http://www.helpmatic.net. I'm not affiliated with them in any
way. It does the job at a reasonable price. You can then have context
sensitive help with something like this:

'in form code
Sub cmdHelp_Click()
XHelp 17 'open help topic 17
End Sub

'in general module
Public Sub XHelp(lContextID As Long)
Dim strHelpFile As String
strHelpFile = shMenu.Parent.Path & "\HelpFile.hlp"
Application.Help strHelpFile, lContextID
End Sub

Robin Hammond
www.enhanceddatasystems.com

"Yoam69" wrote in message
...
Is it possible to create a simple help file in VB for excel without the
use
of a developer tool kit?




Yoam69

Creating a help file
 
Thanks Robin

"Robin Hammond" wrote:

Yes, but there are lots and lots of ways to do it. I eventually ended up
using this: http://www.helpmatic.net. I'm not affiliated with them in any
way. It does the job at a reasonable price. You can then have context
sensitive help with something like this:

'in form code
Sub cmdHelp_Click()
XHelp 17 'open help topic 17
End Sub

'in general module
Public Sub XHelp(lContextID As Long)
Dim strHelpFile As String
strHelpFile = shMenu.Parent.Path & "\HelpFile.hlp"
Application.Help strHelpFile, lContextID
End Sub

Robin Hammond
www.enhanceddatasystems.com

"Yoam69" wrote in message
...
Is it possible to create a simple help file in VB for excel without the
use
of a developer tool kit?






All times are GMT +1. The time now is 08:26 AM.

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