I never thought about validation. That should work perfectly..thanks for your
help!!

Tom Ogilvy wrote:
right click on the worksheet tab and select view code.

then choose the Calculate event.

Private Sub Worksheet_Calculate()
if Range("A1").Value 15 then
Range("A1").NoteText Text:="value is greater than 15"
else
Range("A1").NoteText Text:="acceptable value"
end if
End Sub

If the cell will be altered by editing it, then perhaps you want to use
Data=Validation which does not require a macro, but can be overwritten by
pasting into the cell.

Hi
What about a1 = 15?
[quoted text clipped - 9 lines]
regards
Paul