/VBA/VBA

VBA

'UserForm2 module

Private Sub UserForm_Activate()
    TextBox1.Text = "Activated"
End Sub

Private Sub UserForm_Deactivate()
    TextBox1.Text = "Deactivated"
End Sub

Private Sub CommandButton3_Click()
    Me.Hide
    UserForm1.Show
End Sub

'UserForm1 module

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    UserForm2.Show
End Sub

Source: mrexcel.com

Similar codes

1 vote220 views1 answer
Excel vba unload userform
VBA
0 vote221 views1 answer
Excel vba delete folder
VBA
0 vote225 views1 answer
Vba min
VBA
0 vote240 views1 answer
Find database connection string vb
VBA
3 votes224 views1 answer
Vba make long from two words
VBA
1 vote220 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote225 views1 answer
Show unix time in vba
VBA
1 vote217 views1 answer
Excel vba first and last row and column in range
VBA
0 vote224 views4 answers
How to continue formula in below line in vba code
VBA
0 vote230 views1 answer
Excel vba saveas no prompt for overwrite
VBA