GetKeyBoardState Function
 

Greetings,
I am working on a function to see if Ctrl + S is pressed. Useing the
GetKeyboardState Function is it possible to retirve this information? Also
What I have written crashes excel any ideas what i'm missing?


Dim anArray
Dim Result As Long

On Error GoTo HandleError

anArray = Array(VK_CONTROL, VK_S)

Result = GetKeyboardState(anArray(0))

GetKeyBoardState Function
 

Chip Pearson has a page on this, but using GetKeyState API function:
http://www.cpearson.com/excel/KeyTest.aspx

Cheers,
Dave

"Jeff" wrote:

Greetings,
I am working on a function to see if Ctrl + S is pressed. Useing the
GetKeyboardState Function is it possible to retirve this information? Also
What I have written crashes excel any ideas what i'm missing?


Dim anArray
Dim Result As Long

On Error GoTo HandleError

anArray = Array(VK_CONTROL, VK_S)

Result = GetKeyboardState(anArray(0))