AnsweredAssumed Answered

How to detect keyboard key presses at the start of a macro run

Question asked by Hiyel Kar on Nov 24, 2017
Latest reply on Nov 28, 2017 by Hiyel Kar


I would like to be able to detect if the user has pressed the shift key on the keyboard when the macro started. The user has a macro button on the toolbar for this macro. I want the macro to do task1 when the macro button is pressed, and task2 when the macro button is pressed while the shift key is held. I could achieve this by simply bringing up a msgbox asking the user which of the task they want to do. But it's faster for the user and more sleek if I could do it with pressing the shift button.

Thanks in advance!