As a preliminary I should say I know absolutely nothing about computer programming and therefore nothing about the programming that excel uses.
Anyway I downloaded this software about a week or so ago (Gruss which interfaces with the website betfair). I'm using it to link the odds from the Betfair site into an excel spreadsheet -- so that when the odds change the numbers change in the appropriate linked cells in excel. I wanted an alarm to go off when the odds exceed a certain value. This value I have placed in another cell. I did a search on the net and used the following code:
http://j-walk.com/ss//excel/tips/tip87.htm
Wouldn't work at first -- I just pasted the code in the first window that came up in the programming area. But then I inserted a module and pasted it in that, and now it works with the alarm sounding continuously (looping) when a value in a cell in another sheet linked to the back odds exceeds a value in another cell.
In cell A1 in sheet1 I have =alarm(C1,">B1")
In cell B1 is just a number which I can manually alter.
In cell C1 I have =Sheet2!$F$5
Sheet 2 is where the betfair match odds of a soccer match are imported with cell F5 being the back odds of the home team.
Anyway when cell A1 says false the alarm will go off when I switch to another sheet, or when I open another workbook. It only stops when I go back to the original sheet.
Does anyone have any suggestions as to what is possibly going wrong here? I have zero understanding of the code, but have nevertheless experimented with it, but to no avail. I conclude that computer programming seems to be resistant to an experimental approach in the absence of any understanding of the language!
Any help from anyone would be gratefully appreciated. But any help I'm afraid needs to be extraordinarily simplified so I can follow it.
Bookmarks