VBA - Exit Macro If - Validation

[Olly_S]

Hi,

I'm super new to VBA (althgouh I have a lot of experience with excel) and I have what I presume is a really easy question to solve for.

I've built a data entry form with some validation. Both work fine, but I've added Call Validation_PO (my validation sub) into the data entry Sub, and whilst a message box will pop up is the validation is not satisfied, the data entry form simply continues to run. Code as per;

What I would like to happen is that if the validation sub is not satisfied, then then the other sub stops. Im sure this is possible, but how do I do that?

Thanks!

 

[Olly_S]

Ah figured it out. You simply call the data entry sub at the end of the validation loop. Easy!

 

[Peter_SSs]

Glad you got it sorted.
For the future, if you want help with vba code, please post the actual code (with code tags - see my signature block below) not a picture of your code because we cannot copy from that to test.

 

[Olly_S]

Glad you got it sorted.
For the future, if you want help with vba code, please post the actual code (with code tags - see my signature block below) not a picture of your code because we cannot copy from that to test.

Thanks and noted.