"Caps Lock/Unlock"

[DEG]

Hi Guys and Gals,

Looking for code to lock and unlock caps that will work in both XP and
Vista....anything out there??

Don

 

[Mike H]

Hi,

Have a look here on how to do it but it seems like a lot of bother to me,
why don't you simple convert to upper & lower case as required using UCASE or
LCASE in you code.

http://support.microsoft.com/kb/177674/EN-US/

Mike

 

[DEG]

Hi guys,

Tried to thank you both yesterday for the quick replies but MSN wouldn't
take the reply...so...better late than never...thanks a bunch. Mike your
method worked out great for what I had to do as I didn't have to really lock
the caps, just take data from a combobox and cap it when it was transferred
to the main sheet. But I thank you both...lots of good info...

Have a great weekend,

Don