Microsoft KB Archive/173710

= XL97: Assigning Help Files and Topic IDs in a Visual Basic Project =

Article ID: 173710

Article Last Modified on 11/23/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q173710



SUMMARY
This article describes how to configure a Visual Basic for Applications project to use a specific Help file. The ActiveX and Forms controls in a UserForm can use context-sensitive Help to display Help topics in the Help file.



Assigning a Help File to a Project
Configuring a Visual Basic project to use a particular Help file allows you to assign a Help topic identification number to a control on a UserForm. When you select the control and press F1, the topic in the Help file appears. To assign a Help file to a project, follow these steps:
 * 1) In the Visual Basic Editor (press ALT+F11), right-click any object in the project in the Project Explorer and click VBAProject Properties.
 * 2) In the VBAProject - Project Properties dialog box, type the path and file name of the Help file in the Help File Name box, or click the button to the right of the box to find the Help file. Click OK.

Assigning a Help Topic to an Office Form Control
To assign a Help topic ID to an existing Office form control, follow these steps:
 * 1) In the Visual Basic Editor (press ALT+F11), display the UserForm with the control, and then right-click the control and click Properties.
 * 2) In the Properties window, set the HelpContextId property to the topic ID for the topic you want to appear when F1 is pressed.

Assigning a Help File and Topic at Run Time
Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact a Microsoft Certified Partner or the Microsoft fee-based consulting line at (800) 936-5200. For more information about Microsoft Certified Partners, please visit the following Microsoft Web site:

https://partner.microsoft.com/global/30000104

For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS

You can also assign the Help file and Help topic ID at run time by specifying the HelpFile property for the project and the HelpContextId property for the control. To assign a Help file and topic, follow these steps:   Display the Code window for the UserForm by right-clicking the UserForm and clicking View Code. Click UserForm in the Object list. Click Activate in the Procedure list and type the following code in a Sub procedure:

Application.VBE.VBProjects .HelpFile = .HelpContextId = where is the name of the Visual Basic project.

NOTE: You can use the ActiveVBProject property instead, as in the following example: Application.VBE.ActiveVBProject.HelpFile = "C:\myHelp.hlp" Note that is the path and file name of the Help file and is the object name of the ActiveX control on the UserForm. For example, if you are using the Toolbar control, the statement is similar to the following: Toolbar1.HelpContextId = 1 Also, is the Help topic ID you want to appear when Help is displayed. 

Assigning a Help Topic to an ActiveX Control
To assign a Help topic ID to an ActiveX control, use the HelpCommand and HelpContext properties. To assign a Help topic ID to an ActiveX control, follow these steps:  In the Visual Basic Editor (press ALT+F11), display the UserForm with the ActiveX control, and then double-click the UserForm.  In the Code window for the UserForm, click UserForm in the Object list. Click Activate in the Procedure list. Type the following code in a Sub procedure: Application.VBE.VBProjects .HelpCommand = cdlHelpContext .HelpContext = where is the name of the Visual Basic project.

NOTE: You can use the ActiveVBProject object instead as in the following example: Application.VBE.ActiveVBProject.HelpCommand = cdlHelpContext Note that is the name of the ActiveX control. For example if you are using the Slider control, the statement is similar to the following: Slider1.HelpContext = 10 Also, is the Help topic ID you want to appear when Help is displayed. 

