Detecting Shift-Click

Topic

New Reply

I have attached a number of buttons to macros in my personal.xls workbook. What property (if that’s the right term) can I test from within the macro to see if the Shift key (or Control or Alt) was down when the button was clicked?

Thanks,
Ken

Reply | Quote

Replies

Have a look at the thread
VBA Code to disable NumLock

Reply | Quote

Hans,

Thanks for pointing me in the right direction. It took me a while to figure out that GetKeyState returns bit 8 on when a button is clicked with the shift key down, and bit 1 gets toggled by the key up event. Once I got that, the rest went well.

Ken

Reply | Quote