CHECK BOX HELP PLEASE.

My sheet contains 80 rows. (80 competitors). Their results are posted, one
row to a competitor. Starting on row 7
I have a check box (default €“ unchecked) in cell K7. Its purpose is to
indicate if that persons times should qualify for the event. This check box
will be in Col k on every row. There are three timers. The three times are
averaged to give €œThe Time€�. If they run over their time, this checkbox
should be clicked and the previously entered times in C7,E7,E8 should be
replaced with NIL. I can record a macro to do this on that line, but I want
to use a relative function so that I can copy it down the page to make the
same thing happens on every row (if needed). I have nearly been there but
everytime I get close, I seem to come up with something not quite right. Any
help please much appreciated.

If you posted your code so far it might be easier to correct it.

Without seeing it, maybe this will point you in the right direction,
although it doesn't work from checkboxes, rather I would suggest placing
a button on your worksheet (use freeze panes to prevent it scrolling off
the visible window).

Sub WriteNilInSelectedRows()
Dim r as range
With Selection.Parent
For Each r In Selection.Rows
.Cells(r.Row, 3) = "NIL"
.Cells(r.Row, 5) = "NIL"
.Cells(r.Row, 6) = "NIL"
Next r
End With
End Sub

Sub WriteNilInAllRows()
With ThisWorkbook.ActiveSheet
Range(.Cells(7, 3), .Cells(87, 3)) = "NIL"
Range(.Cells(7, 5), .Cells(87, 6)) = "NIL"
End With
End sub

HTH,
G


SYBS wrote:
CHECK BOX HELP PLEASE.

My sheet contains 80 rows. (80 competitors). Their results are posted, one
row to a competitor. Starting on row 7
I have a check box (default €“ unchecked) in cell K7. Its purpose is to
indicate if that persons times should qualify for the event. This check box
will be in Col k on every row. There are three timers. The three times are
averaged to give €œThe Time€�. If they run over their time, this checkbox
should be clicked and the previously entered times in C7,E7,E8 should be
replaced with NIL. I can record a macro to do this on that line, but I want
to use a relative function so that I can copy it down the page to make the
same thing happens on every row (if needed). I have nearly been there but
everytime I get close, I seem to come up with something not quite right. Any
help please much appreciated.