Linking a Ribbon control with an help file

[Ahasverus]

Hello,

When the mouse hovers over a built-in Ribbon control, you can press F1 to show
the help topic related to it.

Is it possible to achieve the same with a custom Ribbon control, and how ?

Thanks !

 

[Jim Rech]

As far as I know it is not possible because we have no way to know which
control the cursor is hovering over when F1 is pressed.

 

[Ahasverus]

Thanks for the answer, Jim.

Obviously, there are much improvements to do with the new interface.

Jim Rech a écrit :

 

[Chip Pearson]

One work-around that you might be interested in is to test the state of
SHIFT key when the button is clicked. In the code assigned to that control
you could use

Sub Whatever()
If IsShiftKeyDown = True Then
''''''''''''''''''''''''''''''''''
' display help
''''''''''''''''''''''''''''''''''
Exit Sub
End If
''''''''''''''''''''''''''''''''''
' normal macro behavior
''''''''''''''''''''''''''''''''''
End Sub

See http://www.cpearson.com/excel/KeyTest.aspx for info about how to test
the state of the SHIFT key. It isn't as nice as a simple F1, but may be
satisfactory.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)