first of all, hello to everyone, it's my first post here

I need a little help regarding VBA-Code:
I want to record the current back prices of all runners at a specific time e.g. 10 seconds before off.
I tried following code for first runner, but I cannot get it work:
Private Sub Startpreis()
If Tabelle1.Cells(1, 32) = 10 Then
Tabelle1.Cells(5, 34) = Tabelle1.Cells(5, 6)
Else
End If
End Sub
// cell 1,32 is my timer counting down to the start of the event
cell 5,34 is where the price shall be recorded
cell 5,6 is the current back price of first runner
I also tried this if function, but problem is, that price gets resetted to zero again. I don't know if I can avoid that resetting:
=if(AF1=10;F6;)
I only want the price recorded once, every time a market reaches e.g. 10 secs. This is because I need the starting back prices of the runners.
Does somebody know how to do this approriate?
Thanks and regards
Raiden