Custom Ribbon

[ccordner]

Hi

Is it possible to have a callback for the ribbon when a key is pressed, rather than when they press 'tab' or 'enter' - for a dynamic search?

Also, is it possible within VBA to set focus on a Ribbon Control? E.g. after the macro has executed, to go back to the text box in the ribbon?

Thanks
Chris

 

[Worf]

Hi

Check if the custom control has a shortcut key combination. Press ALT to display the tab shortcuts, and then press the key corresponding to the tab where the control is.
If it has a shortcut, it will be displayed.

 

[Worf]

The code below sets focus to a custom edit box in the ribbon. Sending keys is not completely reliable, but very easy to implement.

Sub Edit_Box()
With Application
    .SendKeys "%c"              ' ALT + C to activate the tab
    .Wait Now + #12:00:01 AM#
    .SendKeys "y3"              ' Y3 for the custom edit box
End With
End Sub