Public Const HH_HELP_CONTEXT = &HF ' Display mapped numeric value in dwData. Public Const HH_DISPLAY_SEARCH = &H3 ' Display full text search. Public Const HH_DISPLAY_INDEX = &H2 ' Display the index. Public Const HH_DISPLAY_TOC = &H1 ' Display the table of contents. Public Const HH_DISPLAY_TOPIC = &H0 ' Display the help file. First, paste the following code into a separate module to get access to the API:

You can show a HTML Help (CHM) help topic from your VBA code by using the HtmlHelp API call directly. To show the table of contents you created with HelpScribble's Contents Editor, call: WinHelp(0, strHelpFile, HELP_FINDER, 0) Show HTML Help Topics from Your VBA Code hlp help file, and iContextID is a Long containing the HelpScribble Topic ID of the topic you want to display. Then you can display a particular topic by calling: WinHelp(0, strHelpFile, HELP_CONTEXT, iContextID) where strHelpFile is the full path to the.

( ByVal hWnd As LongPtr, _ ' Declare as Long on older 32-bit only versions of VBA Public Declare Function WinHelp Lib 'user32' Alias 'WinHelpA' _ Public Const HELP_FINDER = 11 ' Show table of contents Public Const HELP_HELPONHELP = 4 ' Display help on using help Public Const HELP_QUIT = 2 ' Terminate help Public Const HELP_CONTEXT = 1 ' Display a given help topic You can show a WinHelp help topic from your VBA code by using the WinHelp API call directly. If the user presses F1 when the control has keyboard focus, the help topic will be displayed. To assign a help topic to a control on a UserForm, simply assign the Topic ID from HelpScribble to the HelpContextID property of the control in VBA. In the dialog that comes up, specify the file name of your help file. In the VBA Editor, select the name of your project, right-click, and select Properties. Note that different instructions apply for VB5 and VB6 as well as VB.NET applications.įirst, you need to specify which help file to use. You can easily create WinHelp files using HelpScribble, and connect them to your Word, Excel and Access VBA applications. UserForms in Microsoft Office applications use WinHelp HLP files by default. How to Provide Help with Office Applications Written in Visual Basic for Applications Context-Sensitive Help with WinHelp Files

Visual basic for excel help