Why not try data validation.
select the cell(s) you wantdatavalidationallow customtype in
=and(a215,a2<75)

--
Don Guillett
SalesAid Software

"W. Adam Glab" wrote in message
om...
I have a cell that data put into it needs to be validated, with upper and
lower limits. 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.