Recognizing Ctl or shift key in VBA
 

Does anyone know a way of recognizing whether the shift key or control key
are pressed from inside VBA. I want a userform button to behave differently
if one of these keys are pressed.

Recognizing Ctl or shift key in VBA
 

Look up in help "KeyDown" and Keycode Constants. It's tricky to explain
here, but the help should be "helpful".

"Rhythm" wrote:

Does anyone know a way of recognizing whether the shift key or control key
are pressed from inside VBA. I want a userform button to behave differently
if one of these keys are pressed.

Recognizing Ctl or shift key in VBA
 

http://www.cpearson.com/excel/KeyTest.aspx
--
HTH...

Jim Thomlinson


"Rhythm" wrote:

Does anyone know a way of recognizing whether the shift key or control key
are pressed from inside VBA. I want a userform button to behave differently
if one of these keys are pressed.