Clearing the Execel status cell(s)

[LetsGoAgain]

I have an Excel workbook which has BetAngel_1.xls as the first worksheet followed by other sheets that I have developed myself to feed lay bets back into the BetAngel_1 spreadsheet from the 60 seconds mark down to the 1 second mark

The problem I have is that I have created an event macro for the BetAngel_1 sheet, code follows
=====================================================
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
If Target.Address = [K3] Then
Range("O9").ClearContents
Range("O11").ClearContents
Range("O13").ClearContents
Range("O15").ClearContents
Range("O17").ClearContents
Range("O19").ClearContents
Range("O21").ClearContents
Range("O23").ClearContents
Range("O25").ClearContents
End If
Application.EnableEvents = True
End Sub
===================================================
which should activate ONCE only when cell K3 changes which is the seconds mark

But it does NOT want do the right thing and clear the STATUS cells

Any assistance would be much appreciated

Thanks

Colin MGregor

[LetsGoAgain]

Further to

Cell K3 contains a link to one of my other sheets (in that it starts with an =)

My reading of event macros is that they won't trigger as a result of a formula (which coukd be my problem)

So how do I change K3 to be the result of VBA code instead of a formulau ???

[TheTub]

I'm not sure I completely understand what you are trying to do but there are a few posts regarding clearing the status cells. Have you looked at them?

viewtopic.php?f=19&t=1879

and

viewtopic.php?f=19&t=30