Onkey method to call Label click event

[sujittalukde]

I am using a userform where only labels are there.
Labels will be clicked and the even is fired.
I have also assigned Shortcut key to labels, but Pressing with ALT key, the code doesnot fire. So I have used Onkey method.
Even this is not firing label caption.
The codes are:


Private Sub Label5_Click()
MsgBox "You Clicked " & Label5.Caption
End Sub


Private Sub UserForm_Activate()
Application.OnKey "%s", "Label5_Click()"
End Sub



Private Sub UserForm_Deactivate()
Application.OnKey "%s", ""
End Sub



Label 5 caption is Select Company and accelerator is “S”

What’s the wrong going on? How can I use keyboard shortcut to fire label5 click event?

Note:
Also posted here (http://www.mrexcel.com/forum/showthread.php?t=549516)

[GTO]

Hi there,

Quickly checked, but I made the userform modeless and it appears that the form cannot have the focus. If the sheet (or naybe more at the window) has the focus, OnKey calls the procedure. If the form has the focus, you just hear faint laughing...

Hope that helps,

Mark

[Kenneth Hobs]

If you are doing it in a userform, set a commandbutton's height to 0, accelerator to "s" and put "s" in the caption name for the button.

Private Sub CommandButton1_Click()
Label1_Click
End Sub

Private Sub Label1_Click()
MsgBox "Label1"
End Sub

[mikerickson]

Perhaps
Application.OnKey "%s", "UserForm1.Label5_Click()"

[sujittalukde]

Thanks Kenneth,for providing a workaround.

mikerickson, its not working.