This blog is a knowledge base...where I clip cool tricks and urls

Events and windows messages in Excel

roos01, after reading about my abundance of memory do you think that is really worth doing? My declarations are as follows:

Module 2:
Private Declare Sub keybd_event Lib "User32.dll" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)
''^Presses any given key
Private Const KEYEVENTF_KEYUP As Integer = &H2
Private Const VK_BACKSPACE As Integer = 8
Private Const VK_TAB As Integer = 9
Private Const VK_SHIFT As Integer = 16
Private Const VK_CONTROL As Integer = 17
Private Const VK_ALT As Integer = 18
Private Const VK_SUBTRACT As Integer = 109
Private Const VK_DEMICAL As Integer = 110
Private Const VK_F5 As Integer = 116
Private Const VK_ACCENT As Integer = 192
 blog it

No comments: