Can Ctrl-Click Event be Trapped with BeforeRightClick logic in VBA?

[Walt]

Hi,

As I understand, on the Mac the Ctrl key and a mouse click are the
equivalent of a Right-Click on a Windows machine. Will an Excel VBA
driven application written on a Windows machine using BeforeRightClick
logic trap the Ctrl-Click Event on a Mac?

I don't have access to a current day Mac to try this.

This is a follow-on question to my Oct 10 post regarding conditional
compilation. Any help will be appreciated.

Best Regards,
Walt Weber

 

[Bernard Rey]

Walt:

As I understand, on the Mac the Ctrl key and a mouse click are the
equivalent of a Right-Click on a Windows machine. Will an Excel VBA
driven application written on a Windows machine using BeforeRightClick
logic trap the Ctrl-Click Event on a Mac?

Yes. Both "Control-click" or "Right click" (when the mouse is fitted with)
fire the "BeforeRightClick" Worksheet event.

 

[Walt]

Hi Bernard,

Thank you. The last time I wrote a user application to run on both
Mac and Windows machines was with Excel version 4.0. Things have
changed a good deal since on both platforms, and I'm trying to
understand and be careful not to over commit to some potential Mac
users of my work. This response helps.

Best Regards,
Walt Weber