New Posts For Thread: Excel VBA help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23538958/excel-vba-help-pleaseI want to call some code when a cell value has been changed by an outside event (such as Gruss)Private Sub Worksheet_Change(ByVal Target As Range) only seems to work if you enter the cell value manually.Is there an alternative that will detect an autBetter forget my post for the time beingIt's is not as simple as I thought it might be.https://community.betfair.com/general_betting/go/thread/view/94082/23538958/excel-vba-help-please?post_id=421074946#421074946Better forget my post for the time beingIt's is not as simple as I thought it might be.Thu, 08 Apr 2010 14:12:42 -0500Ah - exactly. Calcs and conditionals. I've never looked at the screen update commands etc. so I'll give that a go too.cheers.https://community.betfair.com/general_betting/go/thread/view/94082/23538958/excel-vba-help-please?post_id=421074942#421074942Ah - exactly. Calcs and conditionals. I've never looked at the screen update commands etc. so I'll give that a go too.cheers.Thu, 08 Apr 2010 14:12:30 -0500THanks all of you.SLowness was due to my having half a million existing formulas on the sheet which I was going to cut out. (Writing from scratch instead) now.)Think I have it sorted now. tx again/https://community.betfair.com/general_betting/go/thread/view/94082/23538958/excel-vba-help-please?post_id=421074938#421074938THanks all of you.SLowness was due to my having half a million existing formulas on the sheet which I was going to cut out. (Writing from scratch instead) now.)Think I have it sorted now. tx again/Thu, 08 Apr 2010 14:11:20 -0500I'm not too sure why Private Sub Worksheet_Calculate() is slowing everything down to a crawl unless you have lots of formulas,conditional cells etc and you can always turn off the calcultions and screen updates if thats whats slowing it downPrivatehttps://community.betfair.com/general_betting/go/thread/view/94082/23538958/excel-vba-help-please?post_id=421074934#421074934I'm not too sure why Private Sub Worksheet_Calculate() is slowing everything down to a crawl unless you have lots of formulas,conditional cells etc and you can always turn off the calcultions and screen updates if thats whats slowing it downPrivateThu, 08 Apr 2010 14:09:58 -0500You could use conditional formatting with the use of the =now()If (now()is greater than whatever Looking into it to see if I can figure it outI know it works with date() so it should work with now()http://en.kioskea.net/forum/affich-202505-conditiohttps://community.betfair.com/general_betting/go/thread/view/94082/23538958/excel-vba-help-please?post_id=421074930#421074930You could use conditional formatting with the use of the =now()If (now()is greater than whatever Looking into it to see if I can figure it outI know it works with date() so it should work with now()http://en.kioskea.net/forum/affich-202505-conditioThu, 08 Apr 2010 14:00:49 -0500Beyond me I'm afraid, have you tried asking on the gruss forum? Gary's usually very helpfulhttps://community.betfair.com/general_betting/go/thread/view/94082/23538958/excel-vba-help-please?post_id=421074922#421074922Beyond me I'm afraid, have you tried asking on the gruss forum? Gary's usually very helpfulThu, 08 Apr 2010 13:48:58 -0500Thanks Ghetto JoeThanks, I just discovered Private Sub Worksheet_Calculate() but it slows the gruss updates down to a crawl.I'd be happier to use a user-defined function triggered by an 'if' statement in a cell - but I can only semm to make these worhttps://community.betfair.com/general_betting/go/thread/view/94082/23538958/excel-vba-help-please?post_id=421074914#421074914Thanks Ghetto JoeThanks, I just discovered Private Sub Worksheet_Calculate() but it slows the gruss updates down to a crawl.I'd be happier to use a user-defined function triggered by an 'if' statement in a cell - but I can only semm to make these worThu, 08 Apr 2010 13:19:00 -0500I forgot the forum strips out greater than signsPrivate Sub Worksheet_Calculate()If Range("A1") = 10 Then MsgBox "Cell A1 is 10"End Subhttps://community.betfair.com/general_betting/go/thread/view/94082/23538958/excel-vba-help-please?post_id=421074910#421074910I forgot the forum strips out greater than signsPrivate Sub Worksheet_Calculate()If Range("A1") = 10 Then MsgBox "Cell A1 is 10"End SubThu, 08 Apr 2010 13:10:52 -0500Worksheet calculate will detect a change in formula just amend the following Private Sub Worksheet_Calculate()If Range("A1") 100 Then MsgBox "changed"End Subor alternatively use the Private Sub Worksheet_Change(ByVal Target As Range) and log one ofhttps://community.betfair.com/general_betting/go/thread/view/94082/23538958/excel-vba-help-please?post_id=421074906#421074906Worksheet calculate will detect a change in formula just amend the following Private Sub Worksheet_Calculate()If Range("A1") 100 Then MsgBox "changed"End Subor alternatively use the Private Sub Worksheet_Change(ByVal Target As Range) and log one ofThu, 08 Apr 2010 13:08:38 -0500I think you need to keep an oldvalue copy of the cell/s you are monitoring.Use a timer function to check every few seconds if oldvalue equals cell currentvalue. If it does not then a change has been made. Do what you require then set oldvalue to currhttps://community.betfair.com/general_betting/go/thread/view/94082/23538958/excel-vba-help-please?post_id=421074902#421074902I think you need to keep an oldvalue copy of the cell/s you are monitoring.Use a timer function to check every few seconds if oldvalue equals cell currentvalue. If it does not then a change has been made. Do what you require then set oldvalue to currThu, 08 Apr 2010 12:54:00 -0500