?
Solved

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

Posted on 2004-10-16
3
Medium Priority
?
321 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

Invest in your employees with these five simple steps to improve employee engagement and retention.
In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.

801 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