If I use the following formula to cout the Es in a rang
=COUNTIF(E15:E26,"E") I can use conditionsl formatting to advise peopl
making entries into that range if there not enough or too many.

is it possible to write some vb code that defaults the value of th
active cell to 0 if value of the countif function is

--
Message posted from http://www.ExcelForum.com

Private Sub Worksheet_SelectionChange(ByVal Target As
Excel.Range)
If range("wherever the countif formula is").Value 3 Then
ActiveCell.Value = 0
End If
End Sub

-----Original Message-----
If I use the following formula to cout the Es in a range
=COUNTIF(E15:E26,"E") I can use conditionsl formatting to
advise people
making entries into that range if there not enough or too
many.

is it possible to write some vb code that defaults the
value of the
active cell to 0 if value of the countif function is 3


---
Message posted from http://www.ExcelForum.com/

.