Solved

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

Posted on 2004-10-16
3
273 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Ticketing System/ Asset Tag tracking. 4 66
VTP LOG RUNTTIME ERROR 31 142
What interoffice LAN only messenger is recommended? 5 72
mobile app idea 17 57
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
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…

867 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now