[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2004-10-16
3
Medium Priority
?
336 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

656 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