View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
W. Adam W. Adam is offline
external usenet poster
 
Posts: 2
Default VBA and data validation?

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