Solved

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

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Customer support / help desk app 4 90
VTP LOG RUNTTIME ERROR 31 125
PDF to Word 25 105
Craigslist Software for Windows Computer 9 69
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.
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.

757 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

23 Experts available now in Live!

Get 1:1 Help Now