Clearing Bet References

[boycee]

Just to clarify when I hover over x it says x=empty ,but when I hover over x = Range("D2").value it says x=range (D2).value = 1

It's not BA it's a poker bot which pulls in data from Betfair Games into excel and you can set up triggers just like BA

D2 is just the round number eg from 1 - 5

[GeorgeUK]

Is the bot putting the data into D2, or is it a formula?

If its a formula, then we can work with that - otherwise i've no idea why when D2 changes from 1 to something else the worksheet_change event is not triggering.

[boycee]

Bot is putting the data into d2 its always a 1,2,3,4, or 5

i.e. it is never blank - could this be the problem?

[GeorgeUK]

Nope

When D2 = 1 the code should run
When it isn't it shouldn't run.

last ditch attempt
change the code from target.value to target .text

Hopefully it is just being stubborn and it is a formatting bug

[boycee]

Same result I'm afraid.

Thanks for your help George. Really appreciate it mate.

cheers

[GeorgeUK]

Hopefully someone else can come up with something.

If D2 = 1
and it doesn't matter if it is a value or text value...

why does the code not run - are you sure the data is updating (sorry)

Anyone else have any ideas??

[boycee]

yes it loops through 1 to 5 with each round of cards

Except it obviously is not the numbers 1 to 5 or text 1 to 5

What else can produce 1 to 5 if it is not text or numbers

when I key in 1 or "1" the code runs perfectly ?????????????????????????????????

[GeorgeUK]

Possibly

If Target.Count > 1

put an apostrophe '
infront of this line.

It may have a huge flickering effect as it tries to run once for each of the cells being updated

Otherwise i'm stuck. Brain has officially died.

[boycee]

does flicker on update of data but this fix sadly did not work



Just tried an experiment. On the spreadsheet I inserted a little true false statement in P2 =if(d2=1,P3=1,"")

I keyed in 1 to P3 and then let the bot pull in the data to see if P2 came up TRUE or FALSE

Guess what ?

As the bot filled D2 with "1" P2 read .......................................................................................... TRUE

How the feck is that?

The sheet is seeing D2 as 1 even when imported by the bot, but the code is not running on import but does when keyed in?

[Mitch]

I'm guessing it's pepelu's program you are using. For some reason Worksheet_Change events never get fired using pepelu. The way round it is to put "=D5" somewhere below the data (I used A25 but anywhere that doesn't get overwritten will do) which will change each time data is updated, then use Worksheet_Calculate.

To clear O8:O14

Code: Select all

Private Sub Worksheet_Calculate()

     If Range("D2") = 1 Then Range("O8:O14").ClearContents
 
End Sub


That should work but please post back if it doesn't.

[boycee]

Mitch,

Yep that did the business - cheers.

It is peps program - have you tried it with any success ?

boycee

[Mitch]

Only briefly played with it, but there's some conflict or other on my system (or I assume there is) because I can't get the prog to place a triggered bet if there is a macro running.

It did my heed in for a while but I just gave up a couple of weeks ago.