"W. Adam" wrote:

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 ...........................

In VBA, you can use the Range's Validation object.

This is cleaner.

Regards,

John