/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

2 votes315 views2 answers
Excel vba if sunday or staurday
VBA
0 vote284 views1 answer
Change form background image vb
VBA
0 vote316 views2 answers
Excel vba number format file size
VBA
0 vote290 views1 answer
Get current year vb
VBA
0 vote302 views1 answer
Vba static variable
VBA
4 votes338 views1 answer
VBA Deep Clone Dictionary
VBA
3 votes286 views1 answer
Excel vba change format of cell
VBA
0 vote277 views1 answer
Vb net dgv doesn't keep currency format
VBA
1 vote281 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote270 views1 answer
Vba loop through table
VBA