ExcelBanter - VBA method to detect state of CAPSLOCK key?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA method to detect state of CAPSLOCK key? (https://www.excelbanter.com/excel-programming/311054-vba-method-detect-state-capslock-key.html)

Jquads

VBA method to detect state of CAPSLOCK key?

I'm not looking for code to turn CAPSLOCK on or off; I simply want to detect
the state of the CAPSLOCK key.

I'm running Excel10 and 11.

TIA for any suggestions.

All times are GMT +1. The time now is 05:48 PM.