Is there a way to detect what key is being pressed when running a macro? I
am familiar with the Keydown method, but I am using a button from the forms
toolbar not an active X button (so I assume that this procedure won't work).
So, is there a way to detect whether the shift key is being pressed when I
press a button to run a macro? I realize that I could switch the button for
an active X command button, but I would like to learn the answer regardless.
Thanks!