I developed an Excel VBA application (Office 365) on Windows but now need to port it to Mac. One of the features I used depends on VBA being able to to distinguish a SHIFT+CLICK from an ordinary CLICK. As I understand it, this does not work on Mac. Is there any key modifier that CAN be detected on Mac? For example, CMD, OPTION, CTRL, etc.? If not, is there a common workaround?
In case it matters, what is being clicked is a checkbox (form control). The key modifier is detected in the macro handler.