VBA: ONKEY question

Question

hi,  i have been looking for the name given to the Windows key  (bottom left, middle of three keys, #59)

is it possible to select key by key number / how?  otherwise,  the example have is:

Application.OnKey "%{winkey}", "test"    'please help fix this line,  thanks

note:  recommend reestablish ability to mark own answers,  as answered.  i don't care if i don't get any kind of credit for it.  logically,  is otherwise just tricks vs bringing your numbers down.

==========    ANSWER:  found  (tidings, was told couldn't do it)

• in using a key remapping program (key tweak),  i used remap of:  

key 59  (Left Windows)  to  F5  (in excel is:  GoTo popup, may as well have straight up winkey do something else when not using the ALT key).

 - in excel, thisworkbook,  placed:

Application.OnKey "%{F5}", "yourmacro"    'Alt-Left Windows key,  makes it happen

 - in submodule place your macro"

Sub yourmacro()

do what want

End Sub

Answer 1

answer found:

• in using a key remapping program (key tweak),  i used remap of:  

key 59  (Left Windows)  to  F5  (in excel is:  GoTo popup, may as well have straight up winkey do something else when not using the ALT key).

 - in excel, thisworkbook,  placed:

Application.OnKey "%{F5}", "yourmacro"    'Alt-Left Windows key,  makes it happen

 - in submodule place your macro"

Sub yourmacro()

do what want

End Sub

Answer 2

the problem is with the winkey portion,  can that be fixed to its correct name?