GetAsyncKeyState work rclick, not left

**rcamarda390** · 02-08-2011, 12:30 PM

I am trying to trap a left mouse click. I've found code and it works for right click, but not left.

I've defined the function and a worksheet_selectionchage function on a sheet i am testing

This is in my main

Please Login or Register  to view this content.

This is on my sheet

Please Login or Register  to view this content.

When I right click, the msgbox fires. enter, arrow keys and other keys are trapped when I test, but not the stupid left mouse click

TIA
Rob

Office 2010 x32, windows 7 x64

**romperstomper** · 02-08-2011, 01:02 PM

Which version - your sig says 2010, your profile 2003?
In 2007, that code gives me the Left button message for either mouse button.

**rcamarda390** · 02-08-2011, 02:16 PM

I'll check my profile.
I am using Office 2010 x32 and Windows 7 Enterprise x64

**rcamarda390** · 02-08-2011, 03:00 PM

Sigh. The original code I found on the web tested right button first.
the constants are correct, lbutton is 1 and rbutton is 2. Some uses and'ed h8000. Trying to pull a bit mask i guess. Whats frustrating is there are tons of examples using GetAsyncKeyState, some simple, some using different bit masks.
I wouldnt think trapping the left mouse on a workheet SelectionChange would be so difficult.

**rcamarda390** · 02-09-2011, 09:07 AM

Via news groups, I found something important and I dont understand what is going on:
I was using

Please Login or Register  to view this content.

I got more success with

Please Login or Register  to view this content.

Now I find that on some of my sheets, the code will work, but on the sheet I need it, it wont.
I was given this test code

Please Login or Register  to view this content.

On my "working" sheets all codes are trapped, on the sheet I need the left mouse key is not trapped.
I'll update once I find out the cause...I hope is something stupid I am doing...it would be a lesson well learned.

**riyaj m** · 03-31-2016, 09:33 AM

why this &H8000 is used

**Leith Ross** · 03-31-2016, 12:36 PM

Hello riyaj m,

Welcome to the Forum!

The last time this post was active was in 2011. In the future please start a new thread and reference the older thread.

The reason is to check the MSB of the return value which is a Short Integer (16 bits). If the most significant bit is set, the key is down. However, this is not always reliable.