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!