Is it possible for VBA to detect a click with a modifier on Mac?

%3CLINGO-SUB%20id%3D%22lingo-sub-2241410%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20for%20VBA%20to%20detect%20a%20click%20with%20a%20modifier%20on%20Mac%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2241410%22%20slang%3D%22en-US%22%3E%3CP%3EI%20developed%20an%20Excel%20VBA%20application%20(Office%20365)%20on%20Windows%20but%20now%20need%20to%20port%20it%20to%20Mac.%20One%20of%20the%20features%20I%20used%20depends%20on%20VBA%20being%20able%20to%20to%20distinguish%20a%20SHIFT%2BCLICK%20from%20an%20ordinary%20CLICK.%26nbsp%3B%20As%20I%20understand%20it%2C%20this%20does%20not%20work%20on%20Mac.%20Is%20there%20any%20key%20modifier%20that%20CAN%20be%20detected%20on%20Mac%3F%20For%20example%2C%20CMD%2C%20OPTION%2C%20CTRL%2C%20etc.%3F%26nbsp%3B%20If%20not%2C%20is%20there%20a%20common%20workaround%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20case%20it%20matters%2C%20what%20is%20being%20clicked%20is%20a%20checkbox%20(form%20control).%26nbsp%3B%20The%20key%20modifier%20is%20detected%20in%20the%20macro%20handler.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2241410%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

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. 

0 Replies