Validation VBA

[AJC16]

I have a data entry form my employees use. I ha e the validation set up so if certain fields are not complete they trun red and they can't proceed. This process works great. However I need to add a new function. If the " sequence quality" is below 80% I need a comment in the comment box explaining the issue. I can get it to turn the box red and ask for a comment but what I can't get it to do is once a comment is entered it will not process thw entry. It's like it doesn't recognize the data has been entered in the comment box. I'm attaching a screen shot of the form and the validation code I am currently running. Like I said I coded it to require a comment if it's below the threshold is the sequence quality box but will not process once a comment is applied

 

[dmt32]

Hi welcome to form

Its more helpful to forum if you use code tags when posting code – If you look at the menu bar you will see VBA pressing this will produce the tags for you. Place your forms code between the tags.

Also, and if possible, with a complex project, placing a copy of your workbook with dummy data on a file sharing site like dropbox & provide a link saves those that can assist, making a lot of guess work.



Dave