VBA Userforms Help

Program: Excel 2007

Hello I am trying to do a lot of lines of coding & I have split them up into several userforums. How do I activate one userform if the first one does not match.

Basically I have this line of code going over many times with the numbers changed:

If TextBox1.Value = "A" And TextBox3.Value = "3" And TextBox5.Value = "4" And TextBox6.Value = "4" Then UserForm2.TextBox1.Value = (Sheets("Tristian Planet Income").Range("C4").Value + (Sheets("Tristian Planet Income").Range("E4").Value * (UserForm1.TextBox2.Value - 1))) * (1 + ((TextBox4.Value / 10) + (Sheets("Tristian Planet Income").Range("M5").Value) + (Sheets("Tristian Planet Income").Range("M11").Value)))

You have 6 text-boxes with numbers you can put in but I can only go up with this line of code to the value of 3 & I need to go to the value of 6 so I made another userform, but I don't know how to tell the macro to go to the 2nd userform if the values for all the text-boxes is 4 & over.

Let me know if I need to make anything more clear or if you have questions & thanks in advance for the help!