Select Textbox 1 / set focus on userform when another userform closes

[ipbr21054]

Morning,
I have a userform which is open & there is a command button on this form which opens another userform.
When finished with the second userform i wish to select /add focus on Textbox1 when its closed.

I thought there was an event for when form is closed etc but dont see it.
Example.

Open USERFORM1
Press command button to open USERFORM2
Once finished with USERFORM2 its then closed
It is now i wish for USERFORM1 to be selected / add focuse etc

 

[Legacy 143009]

Hi, paste this code in UserForm2:

Private Sub UserForm_Terminate()
  UserForm1.TextBox1.SetFocus
End Sub

 

[RoryA]

You don't need any code in the second userform. Once it unloads it will return control to whatever routine called it, so just set the focus in the next line after the line that showed the other form.

 

[Legacy 143009]

Considering @RoryA 's wonderful suggestion, this can be an option also. You won't need any code in UserForm2:

Private Sub CommandButton1_Click()
  UserForm2.Show
  UserForm1.TextBox1.SetFocus
End Sub

 

[ipbr21054]

Considering @RoryA 's wonderful suggestion, this can be an option also. You won't need any code in UserForm2:

Private Sub CommandButton1_Click()
  UserForm2.Show
  UserForm1.TextBox1.SetFocus
End Sub

This worked for me many thanks.

 

[Legacy 143009]

Happy to hear that Thanks for the feedback