/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 vote215 views1 answer
Excel vba round to whole number
VBA
15 votes412 views2 answers
Xl vba dynamic string array
VBA
2 votes199 views1 answer
Excel vba extract file name
VBA
0 vote190 views1 answer
Vba file chooser
VBA
0 vote173 views1 answer
Vbnet get file name from path
VBA
0 vote203 views1 answer
VBA Sort RossetaCode
VBA
-1 vote205 views1 answer
Code for reading letters only in vb 6
VBA
1 vote204 views1 answer
Vba format string as cash
VBA
0 vote198 views1 answer
Vba code for cutoff time
VBA
0 vote178 views1 answer
Vb window.minimize
VBA