code to intercept 'printscreen' key?

[Keith]

Can anyone point me to a code snippet I could use to run a macro every time
the print screen key is pushed (after allowing the normal printscreen
function of capturing whatever is onscreen as an image)? Basically I want to
automate pasting the new image and doing some other stuff, but I want tit to
be dependent on the printscreen key.... also, I'd like this to occur even if
Excel is not the active window/application, just as long as it is open.

Is this possible, and if so, can anyone point me to examples of how to do
it?

Thanks!
Keith

 

[Excelibur]

To my knowledge, this is not possible. In the code window, type OnKey
and press F1 to get help on it. It displays all the keys you can
intercept in Excel.

If you really need it, it should be possible with external tools like
AutoIt, but I wouldn't recommend it as it will become a messy solution.

 

[NickHK]

If you do not want to trigger the PrintScreen key press, then I guess you
would need to look into a system wide key board hook:
http://vbnet.mvps.org/code/subclass/registerhotkey.htm
http://vbnet.mvps.org/code/hooks/setwindowshookex.htm

If you can provide a button on the WS/Userform, it is much easier. This
should get you started:
http://groups.google.co.uk/group/mi...ab085?lnk=st&q=&rnum=1&hl=en#ebb8eb5535dab085

NickHK