Creating a help file

[Yoam69]

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

[Robin Hammond]

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" <Yoam69@discussions.microsoft.com> wrote in message
news:B5FF46FE-516E-4E5D-9D8C-BD264274FEDB@microsoft.com...
> Is it possible to create a simple help file in VB for excel without the
> use
> of a developer tool kit?

[Yoam69]

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" <Yoam69@discussions.microsoft.com> wrote in message
> news:B5FF46FE-516E-4E5D-9D8C-BD264274FEDB@microsoft.com...
> > Is it possible to create a simple help file in VB for excel without the
> > use
> > of a developer tool kit?
>
>
>