I have a userform that has a command button that shows another userform...But what I need it to do is show that second Userform in the exact same position as the first and then I need the first to unload. Everything I've tried isn't seeming to work....anybody have a bit of code I can put in here to pop it up in the same spot as Userform1 and make Userform1 go away?
Code:
Private Sub CommandButton1_Click()
Unload Me
UserForm2.Show vbModeless
End Sub