ExcelBanter - Keyboard shortcut

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Keyboard shortcut (https://www.excelbanter.com/excel-programming/341856-keyboard-shortcut.html)

[email protected]

Keyboard shortcut

I would like to use a keyboard shortcut to trigger my macro:
Ctrl. + Shift + V.

Is this possible?

Matthew

Bill Martin[_2_]

Keyboard shortcut

wrote:
I would like to use a keyboard shortcut to trigger my macro:
Ctrl. + Shift + V.

Is this possible?

Matthew

1) Go to: Tools Macro Macros
2) Select the macro you want to call
3) Click on Options
4) For Shortcut key, enter a capital V

Bill

Tom Ogilvy

Keyboard shortcut

highlight the macro in Tools=Macro=Macros and click on the Options button.
In the dialog you can set the shortcut key. Put in an uppercase V.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
I would like to use a keyboard shortcut to trigger my macro:
Ctrl. + Shift + V.

Is this possible?

Matthew

[email protected]

Keyboard shortcut

Very nice!

For future reference, is there a way to do Ctrl. + Alt. + V?

Matthew

Tom Ogilvy

Keyboard shortcut

Use a macro to redefine that combination to associate it with your macro.

See the excel VBA help on ONKEY

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
Very nice!

For future reference, is there a way to do Ctrl. + Alt. + V?

Matthew

[email protected]

Keyboard shortcut

Cool.

Thanks a bunch!

Matthew

All times are GMT +1. The time now is 05:36 PM.