 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2004VB script turns off NUMLOCK
I am running a VB script which monitors changes on an Excel spreadsheet and sends out an email. After the script runs, my NUMLOCK is turned off. Why does it do this? Any ideas? Thanks, Berj Show us your code  SignatureRegards Ron de Bruin http://www.rondebruin.nl >I am running a VB script which monitors changes on an Excel spreadsheet and > sends out an email. After the script runs, my NUMLOCK is turned off. Why > does it do this? Any ideas? > > Thanks, > Berj Here is the code which I am using: Dim oldvalue As Variant Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 10 Then Recipient = "lawr99@hotmail.com" Subj = Target(1, -6) & " -- had " & oldvalue & " -- " & Target.Value & " left" msg = "Hi there the workbook is changed" HLink = "mailto:" & Recipient & "?" HLink = HLink & "subject=" & Subj & "&" HLink = HLink & "body=" & msg ActiveWorkbook.FollowHyperlink (HLink) Application.Wait (Now + TimeValue("0:00:01")) SendKeys "%s", True End If End Sub Private Sub worksheet_SelectionChange(ByVal Target As Range) oldvalue = Target.Value End Sub > Show us your code > [quoted text clipped - 8 lines] > > Thanks, > > Berj Your code didn't turn off the numlock for me (xl2002 and win98 and OE6.x). If it's really important, you can toggle Numlock on/off in code. Here's a post from Tom Ogilvy with code from Jim Rech: http://groups.google.com/groups?&threadm=e6%24s58SyAHA.2208%40tkmsftngp02 > Here is the code which I am using: > [quoted text clipped - 35 lines] > > > Thanks, > > > Berj SignatureDave Peterson ec35720@msn.com >Your code didn't turn off the numlock for me The same for me SignatureRegards Ron de Bruin http://www.rondebruin.nl > Your code didn't turn off the numlock for me (xl2002 and win98 and OE6.x). > [quoted text clipped - 43 lines] >> > > Thanks, >> > > Berj It is really weird. It only turns off NUMLOCK temporarily, for a few minutes, then everything is normal. The "NUM" indicator at the bottom right of the spreadsheet does not go away, it still shows as if NUMLOCK is still on. I have tried this on 2 computers with the same results............ Also, the post which was pointed out in an earlier post on Google groups, the poster had the same problem which I had. Berj > >Your code didn't turn off the numlock for me > The same for me [quoted text clipped - 8 lines] > > > > Here's a post from Tom Ogilvy with code from Jim Rech: http://groups.google.com/groups?&threadm=e6%24s58SyAHA.2208%40tkmsftngp02 > >> Here is the code which I am using: > >> [quoted text clipped - 40 lines] > > Dave Peterson > > ec35720@msn.com If you walk away from the pc with numlock off (so there's no chance for interaction), does it get toggled back? Just curious--I don't have any followup guess. > It is really weird. It only turns off NUMLOCK temporarily, for a few > minutes, then everything is normal. [quoted text clipped - 74 lines] > > > Dave Peterson > > > ec35720@msn.com SignatureDave Peterson ec35720@msn.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.