/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 vote100 views1 answer
Extract the second word in a text in excel
VBA
27 votes183 views2 answers
Vba check if file exists
VBA
0 vote103 views1 answer
Vb ternary
VBA
0 vote77 views1 answer
Excel vba first working day month
VBA
3 votes78 views1 answer
Excel vba read registry key value
VBA
3 votes91 views1 answer
Vba post request json
VBA
0 vote86 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote87 views1 answer
Vba sheet visible
VBA
0 vote78 views1 answer
Vb window.minimize
VBA
0 vote86 views1 answer
Method showalldata of object _worksheet failed vba
VBA