I need to be able to detect, in VBA, when the SHIFT key is being held down during a worksheet double-click.
I don't want to make this specific to a workseheet.
What I have tried
I put code in the 'ThisWorkbook' object's 'Sub Worksheet_BeforeDoubleClic
I am using the API function [GetAsyncKeyState Lib "user32"] but am having no success.
I even commented out the use of the API code and just tried to get the double-click event to set the current target to the value of 'Now' and even that is not working.
Can anyone point me in the right directoim to fulfil my requirement ?