F-key for closing form

[Mollethewizard]

Good morning!

Is there a way to close/hide a user form by using one of the F-keys? Any code suggestions?

Greetings Christer

 

[fumei]

Use a KeyPress event.

Gerry

 

[Mollethewizard]

I've tested this code - which didn't work. Why?

Private Sub UserForm_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
ShiftKey = Shift And 7
If KeyCode = vbKeyF2 Then
frmTyp.Hide
End If
End Sub

Christer