VBA and data validation?

  • Thread starter Thread starter W. Adam
  • Start date Start date
W

W. Adam

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
 
See other post.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data validation with VBA 4
VBA code 2
execute assigned data validation in vba? 11
Data Validation List (conditional) 2
make use of cell defined data validation in vba 1
A data validation question 1
validated, stop all calculations on bad data 1
Excel VBA Replace Data Validation Titles and Input Messages 2

Back
Top