Bit of help required with Excel

[doris_day]

I have an algorithm for in-play soccer. I turn the trigger on and off by putting "y" in cell V1 (I know I could use a button instead but I havent much experience with buttons).

What I need is for this V1 cell to be changed to "n" when the market is "Suspended" and left as "n" until I change it back to "y". I can do this so it becomes "n" while "Suspended" is shown but don't know how to make it stay that way until I change it manually.

I'm sure there must be a simple answer.

[Captain Sensible]

Probably easiest just to add a few lines of VBA to any existing Worksheet_Change or Worksheet_Calculate() routines on your sheet


If Range("F2").Value = "Suspended" Then
Range("V1").Value = "No"

End If

[doris_day]

Thanks for that. But will it stay "No" after "Suspended" goes and the game continues ?

[doris_day]

Yes, just tested it. Thats great thanks a lot...