Show Help From VB

If you have compiled help file (.chm) you can show it using the following

Function Call_Application_Help_MyApp(Optional ByVal vHelpText As Variant)

' ---------------------------------------------------------------
' Written By Shanmuga Sundara Raman for http://vbadud.blogspot.com
' ---------------------------------------------------------------

Application.Help "c:\Sample.chm"

' HTML Help, Using Help, Link Application Help with Program
End Function

Technorati Profile

Showing Excel Help

Showing Excel Help

Use this function to show the help; based on helpID

Function Call_Application_Help_Excel(Optional ByVal vHelpText As Variant)

' ---------------------------------------------------------------
' Written By Shanmuga Sundara Raman for http://vbadud.blogspot.com
' ---------------------------------------------------------------

If Val(Application.Version) = 10 Then
Application.Help "XLMAIN10.CHM", vHelpText
Else
Application.Help "XLMAIN9.CHM", vHelpText
End If

' Excel VBA, Using Help, Link Application Help with Program
End Function