I have looked at everything I can find re the status cell
My Strat is on the CS market (soccer)
for testing purposes I am placing a bet at 20 mins before KO
what I cannot for the life of me is how to clear just O9 , so when BA switches to the next game that cell is clear.
I have done all the binding and set the trigger time etc.
Just need to know the VBA code to clear O9
thanks
Andy
help with what looks so simple
-
- Posts: 201
- Joined: Wed Aug 05, 2020 11:45 am
Thank you for your reply, I am just learning VBA, I even went to the library last week to get the Dummies book !
I understand that clearcontents cannot be done in excel so it has to be VBA.
Could you help me just a bit more please, what would I have to write in the module ?
sorry but right now I am that dummy !
Andy
I understand that clearcontents cannot be done in excel so it has to be VBA.
Could you help me just a bit more please, what would I have to write in the module ?
sorry but right now I am that dummy !
Andy
-
- Posts: 201
- Joined: Wed Aug 05, 2020 11:45 am
Derek, just so it makes some sense, what I am actually trying to do, is use excel to do some number crunching (dutching) on the CS market, then put the stakes in the cells, having copied the odds across, I then use the countdown to put "back" in column L at 20 mins before off
The bet is then placed.
what I need to do is clear O9 ( that now has "placed" in it) so when the next game switches on O9 is clear
Any more help would be appreciated
Andy
The bet is then placed.
what I need to do is clear O9 ( that now has "placed" in it) so when the next game switches on O9 is clear
Any more help would be appreciated
Andy
Sorry, I thought you already wrote a VBA routine and wanted to clear O9 from it. I haven't started using Excel integration yet, so I hope someone else comes along to help.goldfinch77 wrote: ↑Tue May 25, 2021 12:02 pmDerek, just so it makes some sense, what I am actually trying to do, is use excel to do some number crunching (dutching) on the CS market, then put the stakes in the cells, having copied the odds across, I then use the countdown to put "back" in column L at 20 mins before off
The bet is then placed.
what I need to do is clear O9 ( that now has "placed" in it) so when the next game switches on O9 is clear
Any more help would be appreciated
Andy
-
- Posts: 201
- Joined: Wed Aug 05, 2020 11:45 am
Hi, I had downloaded the template from betangel for excel integration but cant figure out the codes needed, I think I am trying to run before I can crawl.
Andy
Andy