ExcelBanter - Must be more than 1

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Must be more than 1 (https://www.excelbanter.com/excel-programming/321986-must-more-than-1-a.html)

ben

Must be more than 1

I have a form and do not want someone to be able to enter
a number with a value of less than 1 in D11, D12 & D13.
Can I have a message pop up saying - "Number must be 1 or
more" if they try and write it then move off the cell?

Thanks
Ben

Bob Phillips[_6_]

Must be more than 1

Put data validation on the cell (DataValidation).

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Ben" wrote in message
...
I have a form and do not want someone to be able to enter
a number with a value of less than 1 in D11, D12 & D13.
Can I have a message pop up saying - "Number must be 1 or
more" if they try and write it then move off the cell?

Thanks
Ben

All times are GMT +1. The time now is 10:53 AM.