assing shortcut key to Excel procedure (NL/XP)

Topic

New Reply

Hello all,
When creating custom commandbars I want also to set a shortcut key to the buttons.
Is that possible?
If so,how?

Reply | Quote

Replies

You can assign a macro to a custom toolbar button by setting the OnAction property to the name of the macro.
You can assign a keyboard shortcut to the macro by using Application.OnKey, not to the toolbar button.

Reply | Quote

thanks Hans.

Reply | Quote

You can also put an ampersand character – & – in front of one letter in the commandbar caption. This will specify the character to use as the “Accelerator key” for that command.

In the user interface the selected character will be underlined, like the attached screenshot. So you can use Alt-I, N, R for insert cross reference.

StuartR

Reply | Quote