vb6钩子问题。大哥哥大姐姐们帮帮忙啊

[SmallBear]

Option Explicit
Private Declare Sub CopyMemory Lib "kernel32.dll" Alias "RtlMoveMemory" (ByRef Destination As Any, ByRef Source As Any, ByVal Length As Long)
Private Declare Function SetWindowsHookEx Lib "user32" Alias "SetWindowsHookExA" (ByVal idHook As Long, ByVal lpfn As Long, ByVal hmod As Long, ByVal dwThreadId As Long) As Long
Private Declare Function UnhookWindowsHookEx Lib "user32" (ByVal hHook As Long) As Long
Private Declare Function GetKeyboardState Lib "user32 " (pbKeyState As Byte) As Long
Private Declare Function GetKeyState Lib "user32" (ByVal nVirkey As Long) As Long
Private Declare Function GetKeyNameText Lib "user32" Alias "GetKeyNameTextA" (ByVal lParam As Long, ByVal lpBuffer As String, ByVal nSize As Long) As Long
'Private Declare Sub CopyMemory1 Lib "kernel32" Alias "RtlMoveMemory" (lpvdest As Any, ByVal lpsource As Long, ByVal cbcopy As Long)
Private JPhHook As Long
Private Declare Function GetActiveWindow Lib "user32" () As Long
Private Type KEYMSGS
    vKey As Long
    sKey As Long
    flag As Long
    time As Long
End Type
Private keyMsg As KEYMSGS
'消息
Private Const WH_KEYBOARD_LL As Long = 13
Private Const HC_ACTION = 0
Private Const HC_SYSMODALOFF = 5
Private Const HC_SYSMODALON = 4
'键盘消息
Private Const WM_KEYDOWN = &H100
Private Const WM_KEYUP = &H101
Private Const WM_SYSKEYDOWN = &H104
Private Const WM_SYSKEYUP = &H105

Public Sub EnableHook()
    If JPhHook = 0 Then
       JPhHook = SetWindowsHookEx(WH_KEYBOARD_LL, AddressOf JPHookProc, App.hInstance, 0)
    End If
End Sub

Public Sub FreeHook()
    If JPhHook <> 0 Then
        Call UnhookWindowsHookEx(JPhHook)
    End If
End Sub

Public Function JPHookProc(ByVal nCode As Long, ByVal wParam As Long, ByVal lParam As Long) As Long
    Dim IKey As Long
    Dim strKeyName As String * 255
    Dim strLen As Long
    If nCode = HC_ACTION Then
        CopyMemory keyMsg, lParam, LenB(keyMsg)
        Select Case wParam
            Case WM_SYSKEYDOWN, WM_KEYDOWN, WM_SYSKEYUP, WM_KEYUP:
             IKey = keyMsg.sKey And &HFF
             IKey = IKey * 65536
             strLen = GetKeyNameText(IKey, strKeyName, strLen)
             Debug.Print "键名:" & Left(strKeyName, strLen)
             Debug.Print "虚拟:" & Left(keyMsg.vKey And &HFF, "0")
             Debug.Print "扫描码:" & Format(IKey / 65536, "0")
        End Select
        
    End If
End Function

为什么输出来的 键名和虚拟是空的啊。

[dianyancao]

叫夜闻香过来哼哼哈

[SmallBear]

哈哈哼、vb调试太烂了。真受不了了。
你帮我看看啊。

[神马被哪个妞占用了呢]

死草的灌水机器人……

[dianyancao]

[Quote=引用 2 楼 smallbear888 的回复:]

哈哈哼、vb调试太烂了。真受不了了。
你帮我看看啊。
[/Quote]
实在不会对不起了，ＭＭ会撒谎哈哈

[东方之珠]

很简单的改动。主要是CopyMemory 的参数传输：

Option Explicit
Private Declare Sub CopyMemory Lib "kernel32.dll" Alias "RtlMoveMemory" (ByRef Destination As Any, ByRef Source As Any, ByVal Length As Long)
Private Declare Function SetWindowsHookEx Lib "user32" Alias "SetWindowsHookExA" (ByVal idHook As Long, ByVal lpfn As Long, ByVal hmod As Long, ByVal dwThreadId As Long) As Long
Private Declare Function UnhookWindowsHookEx Lib "user32" (ByVal hHook As Long) As Long
Private Declare Function GetKeyboardState Lib "user32 " (pbKeyState As Byte) As Long
Private Declare Function GetKeyState Lib "user32" (ByVal nVirkey As Long) As Long
Private Declare Function GetKeyNameText Lib "user32" Alias "GetKeyNameTextA" (ByVal lParam As Long, ByVal lpBuffer As String, ByVal nSize As Long) As Long
'Private Declare Sub CopyMemory1 Lib "kernel32" Alias "RtlMoveMemory" (lpvdest As Any, ByVal lpsource As Long, ByVal cbcopy As Long)
Private JPhHook As Long
Private Declare Function GetActiveWindow Lib "user32" () As Long
Private Type KEYMSGS
    vKey As Long
    sKey As Long
    flag As Long
    time As Long
End Type
Private keyMsg As KEYMSGS
'消息
Private Const WH_KEYBOARD_LL As Long = 13
Private Const HC_ACTION = 0
Private Const HC_SYSMODALOFF = 5
Private Const HC_SYSMODALON = 4
'键盘消息
Private Const WM_KEYDOWN = &H100
Private Const WM_KEYUP = &H101
Private Const WM_SYSKEYDOWN = &H104
Private Const WM_SYSKEYUP = &H105

Public Sub EnableHook()
    If JPhHook = 0 Then
       JPhHook = SetWindowsHookEx(WH_KEYBOARD_LL, AddressOf JPHookProc, App.hInstance, 0)
    End If
End Sub

Public Sub FreeHook()
    If JPhHook <> 0 Then
        Call UnhookWindowsHookEx(JPhHook)
    End If
End Sub

Public Function JPHookProc(ByVal nCode As Long, ByVal wParam As Long, ByVal lParam As Long) As Long
    Dim IKey As Long
    Dim strKeyName As String * 255
    Dim strLen As Long
    If nCode = HC_ACTION Then
        CopyMemory ByVal keyMsg, ByVal lParam, Len(keyMsg)
        Select Case wParam
            Case WM_SYSKEYDOWN, WM_KEYDOWN, WM_SYSKEYUP, WM_KEYUP:
             IKey = keyMsg.sKey And &HFF
             IKey = IKey * 65536
             strLen = 256
             strLen = GetKeyNameText(IKey, strKeyName, strLen)
             Debug.Print "键名:" & Left(strKeyName, InStr(strKeyName, Chr(0)) - 1)
             Debug.Print "虚拟:" & keyMsg.vKey
             Debug.Print "扫描码:" & Format(IKey / 65536, "0")
        End Select
        
    End If
End Function

[东方之珠]

还有个地方有误：
Debug.Print "扫描码:" & Format(IKey / 65536, "0")
改成下面就OK了:

Debug.Print "扫描码:" & IKey/65536

[SmallBear]

成功了。
chenjl1031
谢谢哥哥了。

[holam01]

没什么用，但还是谢谢了

[KissVeggieg]

[Quote=引用 5 楼 的回复:]
很简单的改动。主要是CopyMemory 的参数传输：
VB code
Option Explicit
Private Declare Sub CopyMemory Lib "kernel32.dll" Alias "RtlMoveMemory" (ByRef Destination As Any, ByRef Source As Any, ByVal Length As Long)
Priv……
[/Quote]

高人您好！！请教您如何修改才能在EXCEL中使用？