GetAsyncKeyState

I dont know if anyone here has used the following code

Please Login or Register  to view this content.

.. now i need to know where i can get corresponding &H values for combination key presses like say ctrl+m, shift+o or something like that...

please help..

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Did you try google?
http://msdn.microsoft.com/en-us/libr...8VS.85%29.aspx

Did you read what the msdn articles said.

GetAsyncKeyState Function

Determines whether a key is up or down at the time the function is called, and whether the key was pressed after a previous call to GetAsyncKeyState.

So you simple call the function 3 times with the different keys you are testing for.

Of course you gave no explanation of why you are using this API call so it could be there are other ways to determine the information you want.
Perhaps using one of the other API functions mentioned, such as GetKeyboardState which returns the state of all the keys.

If you are controlling the key combinations look at using the .OnKey method rather than muck about with APIs.

I guess your colleagues are developers not excel users.

You said you had control over what key combination.
And your choice is the Left and Right arrow with or without SHIFT key??

If a user does CTRL+RIGHT surely they will jump straight to the last column on the sheet?

If the user does SHIFT+RIGHT the selected area is extended.

Please Login or Register  to view this content.

if I press SHIFT+RIGHT it reports both as being true.

If I press CTRL and then press RIGHT obviously only Right will be true.

Pressing CTRL or SHIFT on their own will not cause the selection change event to fire.