MrExcel Publishing
Your One Stop for Excel Tips & Solutions

WhatsThisButton Help

Posted by Jeramy on December 31, 2001 4:22 PM


I want to add a message so that when a user presses the question mark on the userform then clicks the button a help message will pop up. I set the whatsthisbutton to true, but where do I put the message to be displayed?



Posted by Dank on January 01, 2002 7:02 AM

Unfortunately you can't use the WhatsThisHelp button in this way. It works like this:-

Firstly, you need to create a help file for your application (not a trivial task).

Then you must assign this help file to your project (Tools, VBA Project properties, Help File Name).

When you create a help file each help page can have an ID assigned to it. You need to assign a HelpContextID to the form or control on your userform. This way, when a user clicks the Whatsthisbutton and then clicks on a control the help page associated with that particular control will be displayed. This can be demonstrated by clicking on a propery in the properties window (e.g. Caption) and pressing F1. The help for Caption in the VBA help file appears.