VBA for Caps On notification

[Neilesh Kumar]

Dear Experts,

I am using userid and password for opening and closing an excel workbook by using a Userfom. Is it possible to upgrade the below script for the Caps On or Off notification while typing password in the password text box.

So if my caps is on while typing the password in the text box then it will popup a notification or message for the Caps On.

Please Login or Register  to view this content.

Request to you kindly provide your precious expertise on the same.

Many thanks and Regards,

Neilesh

[CK76]

You'll need to access Windows API.

zacemmel's post in link below is a good starting point.
https://www.mrexcel.com/forum/excel-...slock-vba.html

Have a read of link. If you have issue implementing, ask for help here.

[Neilesh Kumar]

Thank you so much CK76, i was exactly looking the same. Thank you once again.

Regards,

Neilesh