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
Worksheet_BeforeDoubleClick + Ctrl
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Worksheet_BeforeDoubleClick + Ctrl
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78488
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Worksheet_BeforeDoubleClick + Ctrl
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
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Worksheet_BeforeDoubleClick + Ctrl
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.
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.