Bind 1 or more keystroke to 1 or more macro's

[mbdigital]

Hi all out there.

I have a VBA code in my worksheet which binds a key stroke to a macro :

Please Login or Register  to view this content.

This code binds CNTRL-s to the macro "SELECTIEBLAD".
I would like to use CNTRL-SHIFT-s for this macro.
How do I change the code so that it's not CNTRL-s but CNTRL-SHIFT-s ?

Furthermore I would like to ask how I can use this code to bind more keystrokes to more macro's,

such as CNTRL-SHIFT-v for the macro "VOORBLAD"
and CNTRL-SHIFT-o for the macro "OFFICES"
and CNTRL-SHIFT-c for the macro "CLIENTS".

I have tried some changes which I thought where good, but it keeps me giving debugging errors.

It would be greatfull if somebody could help me with this.

[naveenmarapaka]

Have you tried, editing the macro options.

Go to View -->Macros -->View Macros ...
Highlight your macro , then click on Options, you will get a dialog box with options shortkey .... it will show your current shortcut if any... you can just change what ever your want....
By Default you will see Ctrl + [] to select , Here you can Hold Shift on keyboard and enter the letter you want to set to Macro...

That's it..

[mbdigital]

Hi naveenmarapaka.

Thanks for your idea, but as the macro's are all private, they are not visible in the way you suggest and therefore not accessable via normal keystrokes.

Therefore I have to use this code to bind keystrokes to (private) macro.

So your idea is unfortunately not an option.

[naveenmarapaka]

Hi,
Code is not required to assign to macro....
Try to put Developer Tab in your menu options of excel ( File ->Options ->Customize Ribbon ->select developer on right menu options).. then try above method... if you are not able to view it...

Note : Do not try to assign a Predefined Keystroke to a macro as it will override the normal behavior
Example : ^S Normal behavior is to save in excel ..

[mbdigital]

Hi. Remember that private macro's can not be called by keystrokes.

[romperstomper]

It's:
"+^S"
for Ctrl+Shift+S

Just repeat the OnKey for your other key/macro combinations.

[mbdigital]

Hi Rory.

Thanks for your reply.
This is what I was looking for but how do I seperate the several onkeys?

Please Login or Register  to view this content.

[romperstomper]

You need multiple OnKey statements:

Please Login or Register  to view this content.

[mbdigital]

Hey Rory ....

This works perfect !!!

Thanks a lot for your clear and fine help.

[romperstomper]

Glad to help.