/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

0 vote296 views1 answer
Vb test if reference is null
VBA
0 vote294 views1 answer
Excel vba formatconditions range
VBA
5 votes352 views1 answer
Excel vba right word from Long Integer
VBA
0 vote343 views1 answer
Vba count all row
VBA
0 vote323 views1 answer
Vba createparameter null
VBA
2 votes306 views2 answers
Constructor vb.net
VBA
0 vote310 views1 answer
Vba line feed
VBA
0 vote305 views1 answer
How to make a a msgbpx in vbs
VBA
1 vote319 views1 answer
Vba reverse string
VBA
1 vote375 views1 answer
Excel vba convert text YYYYMMDD to date
VBA