Excel - Clear Status Cells

[GreyTrader]

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

[ODPaul82]

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

[GreyTrader]

Thanks

I figured it could be along those lines from what I have viewed, this was quoted somewhere...

Private Sub Worksheet_Change(ByVal Target As Range)

Along with others I neglected to copy

[ODPaul82]

Thanks

I figured it could be along those lines from what I have viewed, this was quoted somewhere...

Private Sub Worksheet_Change(ByVal Target As Range)

Along with others I neglected to copy

There is an order of precedence in the Excel VBA model that some routines will trigger recursively like Calculate(), Change is in there as well
I'm purely C# these days so don't remember exactly how it is but google to find whats optimal so you're front of queue as much as possible.