PDA

View Full Version : Detecting Keystrokes



MWE
10-01-2010, 02:54 PM
Does anyone have experience detecting individual keystrokes in "real time"? I wish to be able to detect when the user presses any key and do something based on which key was pressed. Using, say, InPutBox requires three steps:
the appl calls Inputbox for each piece of data
the user enters something
the user either clicks on a button or hits the return key.I want to "monitor" the keyboard and thus eliminate the first and third steps

Bob Phillips
10-01-2010, 03:02 PM
It's easy enough in a userform textbox using the KeyPress event.

MWE
10-01-2010, 05:15 PM
It's easy enough in a userform textbox using the KeyPress event.Thanks. That approach worked out well.