Refresh rate and VBA

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

rain91 wrote:
Mon Apr 23, 2018 5:53 pm
Hi ShaunWhite,

it works good, but:

i will now run it in multiple Bet Angel sheets, and it doesnt work.

Only work in the last started active sheet. So i connect my spreadsheet to Bet Angel, i start macro in "Bet Angel", start macro in "Bet Angel (2)", start macro in "Bet Angel (3)". Macro work only in "Bet Angel (3)" :/
Maybe have one routine that looks at all sheets.
I have one start & stop button on a dashboard page ...and the code finds the sheets I'm interested in.
rain91
Posts: 112
Joined: Tue Feb 07, 2017 7:11 pm

Yes, i placed for all 3 worksheet Start/Stop button. If i connect to BA, i start it on all 3 worksheet, but VBA run only on active (what i am seeing).

With worksheet calculate is good in multiple spreadhseets, but too slow the refresh rate (about 1sec), the computer isnt strong. (i5 3470 cpu).
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”