Excel VBA Turn On Num Lock

Josh Hazel
07-15-2010, 08:48 PM
Stupid question, but isn't there a simpler way to turn on/off num lock key then this site: http://www.freevbcode.com/ShowCode.asp?ID=1144

It just seems like it is overly complicated

ZaCkOX
07-15-2010, 10:03 PM
You might be able to sendkeys numlock somehow, but what you have is the correct way to do it. Awhile back I tried looking for ways to turn it off and all I got was the same way you have.

Josh Hazel
07-16-2010, 03:03 PM
Actually SendKeys seems to be the cause of my trouble... it seems some combination of my SendKeys is causing Num Lock to be turned off! Which is fouling up the users after the code runs they have to turn num lock back on

Bob Phillips
07-16-2010, 03:05 PM
http://support.microsoft.com/default.aspx?kbid=179987
BUG: Multiple SendKeys Statement Turns Off NumLock Key

webbone
07-16-2010, 04:21 PM
You could possibly simplify the code you referenced if you don't need to support Win 9x, but that is the method most of us use to set the state of CapsLock, NumLock, etc. - it really isn't all that cumbersome.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum