Hey there guys. I'm trying to revamp one of my macros so that it will pull up a new userform based on information input into the first userform. What I can't figure out is how to get the system to call the second userform once it's figured out the if/then statement. The code I'm trying to use is pretty simple, but I keep getting errors and it won't pull up the second userform. I was hoping someone could help me fix my code so that it'll work properly. Here's what I have:
Code:
I'm sure I'm doing something wrong here, but I'm not sure what it is. Anyone able to help would be greatly appreciated. Thanks!
Code:
Code:
If Box1.Text = "Yes" Then
Call Userform1
End If
I'm sure I'm doing something wrong here, but I'm not sure what it is. Anyone able to help would be greatly appreciated. Thanks!