• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Validate Sheet

lesley burlingham

lesley burlingham

Member
I have finished my spreadsheet and I would liek to have a final check to make sure all mandatory fieklds have been populated. The user select a button to go to the next sheet. Is it possible to add some validation to the command button to check all the mandatory fields.

Thanks
 
Hi Lesley ,

You can use the COUNTA / COUNTIF / COUNTBLANK functions and enter a formula in a designated cell to check whether all the fields have been populated or not ; when the command button to navigate to the next sheet is clicked , the code can look at this cell which has the formula , and see whether it says that all fields have been populated or not.

Narayan
 
Lesley - I use VBA to do this. Can you code? I can supply a sample file, but it's pretty complicated and I don't have time to amend it to your ends.
 
You must log in or register to reply here.
Back
Top