Can Fkeys be used similiar to _beforedoubleclick(

[Gary Hardy]

Is there any way to use an Fkey to do something in a worksheet
similiar to using the worksheet_beforedoubleclick( command.
Thanks..Gary

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **

 

[Dave Peterson]

You can assign a macro to any of the F keys, if that's what you're asking.

For instance:

Option Explicit
Sub EnableShortCuts()
Application.OnKey "{F10}", "doMac1"
Application.OnKey "{F11}", "doMac2"
Application.OnKey "{F12}", "doMac3"
End Sub
Sub ResetShortCuts()
Application.OnKey "{F10}"
Application.OnKey "{F11}"
Application.OnKey "{F12}"
End Sub
Sub doMac1()
msgbox "From Mac1"
End Sub
Sub doMac2()
msgbox "From Mac2"
End Sub
Sub doMac3()
msgbox "From Mac3"
End Sub