Need Help Please: I am rying to write code to validate a cell is greater than null on leaving and msgBox / reactivate cell if validation is false
Thanks
Need Help Please: I am rying to write code to validate a cell is greater than null on leaving and msgBox / reactivate cell if validation is false
Thanks
Hi J,
Have you tried using Data / Validation on the cell? You can specify text length, or numeric values, or specific item from a list and give your own custom error message.
(it's on the Data menu).
Post back if this doesn't give you what you need.
.....Ralph
Hi Ralph:
Thanks for the reply. I am setting up a spread sheet that will be used by several people, many very novice. I am concerned with data validation that because when the workbook is initially opened all the cells that I want to validate will be null and the error messages active. This would be very confusing to several users. I would rather have a message box with a clear error description and solution.
Thanks again
Josh
JJacob, I think that data validation will work for you. You can customize the error messages and the error-messages will not appear when the spraedsheet is opened - only when a user changes specific cells.
You would like an error message when a user leaves specific cells, but what if they never enter the cells? They could leave the cells as null and still close the file? Or are the cells pre-populated?
The other approach would be to use VBA code. A Workbook_BeforeSave function could check for null cells before saving & give an error message.
Thanks for the help guys. It may be to use Data Validation in Excel
Don’t have an account yet? Register yourself now and be a part of our community!