Worksheet_BeforeDoubleClick + Ctrl

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Worksheet_BeforeDoubleClick + Ctrl

Post by ABabeNChrist »

Is it possible to use a Worksheet_BeforeDoubleClick + Ctrl together
I figured out how to use with just a double click but not a Worksheet_BeforeDoubleClick
I came across an inquiry regarding this approach, not that they were able to do it but were just inquiring. So I got really intrigued and have been fiddling around trying different thing using my puny little brain. This workbook below was the closest I was able to get, my be someone else may have a better idea.
Is it even possible :scratch:
Double Click + Ctrl.xlsm
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78488
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Worksheet_BeforeDoubleClick + Ctrl

Post by HansV »

As far as I can tell, Excel treats a double-click on a cell as a single click if you hold down Ctrl, Shift and/or Alt - the second click is simply ignored. So I don't think there is a way to check the Ctrl key directly in Worksheet_BeforeDoubleClick.
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Worksheet_BeforeDoubleClick + Ctrl

Post by ABabeNChrist »

Thank you Hans
Even though I'm still very new to VBA I enjoy a little challenge. If anything it will help sharpen what little skills I do have. :grin: