How to exit from user form's Initialize

[USAMax]

I have two userform combo boxes, the second follows up on the results of the first.

The second Combo Box looks for incomplete fields and provides them in a drop box. If the data the second Combo Box is looking at (This is different data than the first Combo Box is looking at.) is complete it updates the field, if not then it adds it to the drop down list.

My problem is this, if it finds everything updated and nothing is added to the drop-down list, how do I exit? I just want a complete break where all programming ends.

I am in the Initialize subroutine and I have tried Exit Sub and it still brings up the user form.

 

[JLGWhiz]

I have two userform combo boxes, the second follows up on the results of the first.

The second Combo Box looks for incomplete fields and provides them in a drop box. If the data the second Combo Box is looking at (This is different data than the first Combo Box is looking at.) is complete it updates the field, if not then it adds it to the drop down list.

My problem is this, if it finds everything updated and nothing is added to the drop-down list, how do I exit? I just want a complete break where all programming ends.

I am in the Initialize subroutine and I have tried Exit Sub and it still brings up the user form.

Unload Me

 

[USAMax]

Thank you JLGWhiz, unfortunitly that was the first thing I tried but in the Initialize subroutine that does not work. I took me almost an hour Googling this but all I needed was End.

I tried End Sub and a few more forms of End but that was all I needed to exit everything.

Thank you.

 

[JLGWhiz]

Thank you JLGWhiz, unfortunitly that was the first thing I tried but in the Initialize subroutine that does not work. I took me almost an hour Googling this but all I needed was End.

I tried End Sub and a few more forms of End but that was all I needed to exit everything.

Thank you.

Ok, I thought you just wanted to get out of the form. Yes, End stops it all.
Regards, JLG