/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 vote111 views1 answer
Vba dropdown event
VBA
0 vote131 views1 answer
Not allow form to be resized
VBA
1 vote146 views1 answer
Extract the second word in a text in excel
VBA
0 vote130 views1 answer
Vba format currency
VBA
0 vote131 views1 answer
Show unix time in vba
VBA
5 votes143 views1 answer
Vba low byte from INTEGER
VBA
1 vote129 views1 answer
Vbscript convert ascii code to character
VBA
0 vote80 views1 answer
Vba set vs dim
VBA
4 votes133 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote139 views2 answers
Checking and changing system volume vb.net
VBA