CLEAR (again)

[London_Calling]

I must have a blind spot on this because I’ve searched and been reading the achieve for an hour, can someone please help me from going mad:

1) The first bet is placed with a formula
2) The second bet is triggered and VBA/Worksheet_Calculate puts the elements of the bet in place

But I just can’t workout how to CLEAR the relevant Q/trigger cell of the first bet (so the second can fire)

I see in threads you just have to put CLEAR in the bet reference column . . . but how, my VBA reads: [T5] = "CLEAR" which just puts CLEAR in that cell and leaves it there - no bet ?

Help, please !

[GaryRussell]

CLEAR is a trigger like BACK and LAY, it's only function is to clear the bet ref, time, matched odds and stake. So clear belongs in cell Q5. All you have to do is change your code to [T5] = "" and BA will fire another bet because the bet ref is blank.

[London_Calling]

Gary - appreciate the quick reply, makes perfect sense. Fwiw, I did start with = "", so your reply means my problem lays elsewhere in the VBA. Cheers.


*going slightly mental"

[London_Calling]

Gary - Can you help me take this one step further ?

As above, [T5] = "" clears the cell as required for the next bet. But the problem then is that when the second bet fires, T5 clears instantly because the VBA code is still there. In other words, even though Q5 says BACK T5 is empy becasue the VBA says [T]= "".


Sorry, I'm sure I'm missing something really simple . . . I'm just having such a time on this issue.

Thanks.

[GeorgeUK]

If i'm following this right, what you want is:

T5 to be blank
Bet2 to be made

so what i would suggest is using the CLEAR in the Q column as Gary suggested

IF T5 <> "" AND Q5 <> "CLEAR" then
Q5.value = "CLEAR"
Q5.value = Bet2
end if

So this should only activate when a bet has been made, and there is a betref in T5
If it is a lay then back bet you are doing, to stop this firing clear then the bet2 constantly, you need either a counter to count how many times this code has run - and bets made, or you can add to the first line AND Q5 <> "BACK" (If this is what bet2 is doing)
Then the code won't activate if the trigger is either clear or back.

[London_Calling]

Thanks for trying to come to my help George, much appreciated.

Just twigged I've been using CLEAR in the T column, so I'll work on it now with Q - as you and Gary both suggest. I'm blaming the dyslexia.

Fingers crossed the T >< Q issue is at the root of why I'm just not getting this.

Thanks again, I'll report back tomorrow.

[London_Calling]

Just a note to say thanks to Gary and George, I got there in the end thanks to your help.

The code's less than impressive at the moment but I have hope . . . . Cheers.

[knot]

could somebody please retype this so i can copy and paste as i am usless at this. formulas im ok but not this. im trying to place a back bet then lay at 1 tick less and repeat the back/lay until a certain cindition is met. the problem being i dont know how to clear the bet ref so another bet can be placed