Ouais ...
Alors voilà :
Private Type Msg
hwnd As Long
Message As Long
wParam As Long
lParam As Long
time As Long
End Type
Private Declare Function RegisterHotKey Lib "user32" (ByVal hwnd As Long, ByVal id As Long, ByVal fsModifiers As Long, ByVal vk As Long) As Long
Private Declare Function UnregisterHotKey Lib "user32" (ByVal hwnd As Long, ByVal id As Long) As Long
Private Declare Function PeekMessage Lib "user32" Alias "PeekMessageA" (lpMsg As Msg, ByVal hwnd As Long, ByVal wMsgFilterMin As Long, ByVal wMsgFilterMax As Long, ByVal wRemoveMsg As Long) As Long
Private Declare Function WaitMessage Lib "user32" () As Long
Private Declare Function FindWindowA Lib "user32" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private monhwnd As Long, basta As Boolean
Private Sub userform_Initialize()
monhwnd = FindWindowA(vbNullString, Me.Caption)
basta = False
RegisterHotKey monhwnd, &HBFFF&, 0, vbKeyA
Show
ProcessMessages
End Sub
Private Sub ProcessMessages()
Dim Message As Msg
Do While Not basta
WaitMessage
If PeekMessage(Message, monhwnd, &H312, &H312, &H1) Then
MsgBox "voila ! tu viens de presser la touche A ! mets ici tes instructions à la ^place de ce msgbox"
End If
DoEvents
Loop
End Sub
Private Sub UserForm_Terminate()
basta = True
UnregisterHotKey monhwnd, &HBFFF&
End Sub
Lance, presse la touche A et vois ...
________________________
Réponse exacte ? => "REPONSE ACCEPTEE" pour faciliter les recherches.
Pas d'aide en ligne installée ? => ne comptez pas sur moi pour simplement vous dire ce qu'elle contient. Je n'interviendrai qu'en cas de nécessité de développ