Thanks much for your help. I'm obviously not proficient with this level of
programming.
One last question....your code works but is it possible for the Message Box
to appear without having to select the cell?

" wrote:

Try inserting the following code into your worksheets code module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If ActiveCell.Column = 3 And _
ActiveCell.Value 2499 Then
MsgBox _
"Please make sure that the value here is less than 2,499."
End If

End Sub

This will allow any value but show a message if the value exceeds 2499.
This will only work for column "C" entries. You may change that by
changing the "3" value in the "IF" statement.

Hopefully this will get you started and then you can taylor it to your
needs