link key from keyboard with button to run the code instead of click on the button

[MKLAQ]

Hi guys
I have project contains many buttons inside the sheet whether active X or not and userform contains commandbuttons .
so I want to use the key from keyboard to running the code instead of click the button .
example :
button 1 (inside sheet) = F1 from keyboard
commandbutton1 active X (inside sheet)=C (letter from keyboard)
commandbutton1 (onuserform)= F3 from Keyboard and so on for each button .
also posted here
link key from keyboard with button to run the code instead of click on the button
thanks in advanced.

 

[Trevor G]

There are key functions you shouldn't use and this YouTube video will show/suggest how to assign them.

On a user form in VBA you can assign an accelerate key which will underline a letter then you can use that letter on w the user form is displayed.

 

[Trevor G]

I meant use the Alt key with the letter. Like wise with an ActiveX button you can assign an accelerator.

 

[MKLAQ]

thanks for the video .
I try to add {ENTER} instead of letter, but doesn't work .
I note shortcut should use CTRL+SHIFT+ ...
what about just use CTRL alone with letter or just letter alone when active sheet?

 

[Trevor G]

Take a look at this video it will show you how to use application.onkey method. Be careful though as you need to switch things off before closing the workbook.

 

[MKLAQ]

with this try doesn't work for me

Private Sub Workbook_Activate()
Application.OnKey "^E", "macro1"
End Sub

Private Sub Workbook_Deactivate()
Application.OnKey "^E", ""
End Sub

Sub macro1()
MsgBox "hi"
End Sub

 

[Jaafar Tribak]

Private Sub Workbook_Activate()
    Application.OnKey "^e", Me.CodeName & ".macro1"
End Sub

Private Sub Workbook_Deactivate()
    Application.OnKey "^e", ""
End Sub

Sub macro1()
    MsgBox "hi"
End Sub

 

[MKLAQ]

Thanks Jaafar
when I use CTRL+E
doesn't run the macro just show EXCEL message !

 

[Trevor G]

Your macro1 only indicates a message box! Nothing else.so what is the macro name as well as what is the code within the macro?

 

[MKLAQ]

Your macro1 only indicates a message box!

that doesn't mattter . just to test your suggestion .

what is the macro name

what about post#6 ?!

what is the code within the macro?

regardless what the code contains. should run without problem if the macro name is correct.