Does anyone have a good technique for testing in a VBA
macro whether the Caps Lock key is turned on. I'd like
the macro to do something different based on whether the
user hits "l" or Shift-"l" to initiate the macro.

I expect this has been asked before and I apologize if
this is a totally "duh" question . . .