Solved

How do you set up Context sensitive help for userforms for MS Excel(Office XP)?

Posted on 2004-10-16
3
284 Views
Last Modified: 2012-05-05
Created .chm file with Microsoft HTML Help Workbench.

In my Excel visual Basic Editor I used 'VBAProject Properties:Help File Name' to enter the name of my .chm file.

Each control on my userform shows two properties  'ControlTipText' and 'HelpContextID'

'ControlTipText' seems to work OK.

HelpContextID asks for a numeric value not the name of a topic in my .chm file.

How do I bind/map topics in the .chm file to individual controls on my userform so that I can use
<F1> key to direct me to that topic?

0
Comment
Question by:salitasc
  • 2
3 Comments
 
LVL 6

Expert Comment

by:david_barker
ID: 12332854
Follow the instructions in the Help for the Workshop, under Creating Help -> Hook-up to a help program -> Create Context-Sensitive Help -> Example.
In a few words, it will require using a header file to map the symbolic IDs to numerical values.
Have fun !
0
 

Author Comment

by:salitasc
ID: 12343468
I read the section in HTML Help Workshop on how to create a header file.

Line syntax for entries in the header file:

#define  IDH_symbolicID       <numeric ID>

In regards to my question concerning userforms in Excel and context sensitive help that can be triggered by <F1> ...

It is unclear what symbolicID to use for a particular control on the userform. I tried to append the name of the control to "IDH_"

example:

for a control named "ControlButton1" I formed the header file line below:

#define IDH_ControlButton1     1000

In the HTML Help Workbench:
I included the header file in my project and
created an alias to bind numeric ID 1000 to a specific topic in my project.

when I used this setup, the following message was seen when <F1> was hit with the cursor over the "ControlButton1" control

"No Help topic is associated with this item."

How do I determine what symbolicID should be used for a specific control on my Excel userform for <F1> help to connect to topic?
It's unclear how to get more feedback as to how I'm failing to connect to the topic in the .chm file.
0
 
LVL 6

Accepted Solution

by:
david_barker earned 500 total points
ID: 12345084
I'd missed the fact that you are using Excel.
You'll have to call directly HHCtrl.ocx.
Have a look at http://www.microsoft.com/resources/documentation/office/2000/all/solution/en-us/part2/ch13.mspx
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
A list of useful business intelligence software.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question