Hi All
I am working through excel to automate some trading. I currently have ‘time to post’ placing bets at 15 second intervals from 1 min 30 seconds to 30 seconds to post, 5 in all.
What I am trying to do is automatically clear the status column from 1:35 seconds to 00:50 seconds to go so it makes ‘ready’ excel for the next bet 5 seconds later. I don’t want to clear the Status column after the bets at 00:45 seconds.
I have used the same process for the trigger as the placing bets (which work fine) but must use a macro to clear the Status cell contents. However, it never triggers even though I have watched the trigger activate, as with the placing, so I am guessing I have the macro incorrect.
This is what I currently have in the macro, a Chat GPT suggestion.
Sub Placed()
If Range("G90").Value = 1 Then
Range("O9:O68").ClearContents
End If
End Sub
I have tried several macros from google and the forums, but I guess I am missing something. My VBA knowledge is somewhat limited, and I struggle to understand some of the suggestions I found in the forum and via google / AI chat etc.
Can anyone enlighten me?
TIA Andy
Excel - Clear Status Cells
You need to actually trigger the procedure Place()
It's been about 18 months since I last did VBA in connection to BA but it will be along the line of needing to trigger it in Worksheet_Calculate()
It needs to be associated with an event of some form
It's been about 18 months since I last did VBA in connection to BA but it will be along the line of needing to trigger it in Worksheet_Calculate()
It needs to be associated with an event of some form