How to assign a hotkey to a command button macro

[billyheanue]

Hi all,

I have code that starts with

Private Sub CommandButton3_Click()

and I am wondering how to go about assigning a hotkey to it instead of having to use the command button.

Any pointers?

thanks!

 

[bewsh1987]

press Alt+F8

then select the macro click options

 

[XLRATOR]

Hello,

1. Hit the Record Macro Button in the Developer Tab
2. Give the Macro a name and in the shortcut Key hit the key of your choice in the Keyboard to be used as hotkey and press ENTER
3. Do a single action as selecting any cell
4. Stop the macro recorder
5. Go to the VBA Editor, and look for the new module just been created by Excel when recording the macro
6. Replace the content of the macro by your code.

That would be it.

 

[XLRATOR]

bewsh1987's is even a better approach.

Thanks dud.