I'm trying to use the keystrokes as a filter. For example when the user starts to type i have a small form pop up and he can type what he wants to and click enter. This filters a listbox on a master form.(I pop the form up on a key press event but i always loose the first key the user pressed. )
It's kind of laborious, but you might want to try putting key down handlers in each form (and each control in each form). That seems to catch all the keyboard events. If you don't want to pass the keystroke on to the application, set the keycode and shift to 0:
Sub ProcessKeyDown(KeyCode As Integer, Shift As Integer)
Debug.Print "Down: " & Format(Now, "HH:NN:SS" & ", " & KeyCode & ", " & Shift
KeyCode = 0
Shift = 0
End Sub
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.