Who says you can't set upper and lower limits using Data
Validation?

Data Validation,
Allow: Custom,
Formula:

=AND(A1=15,A1<=75)

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a cell that data put into it needs to be
validated, with upper and
lower limits can't use data validation, it has to be VBA
code). Need to
write click event which will control data input within
the limits, for
example:
Input box can only accept between 15 and 75, any idea how
to write the code.
Do while numbers ...........................


Loop

Thanks for your help


.