/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 vote148 views10 answers
Vba excel create event log
VBA
0 vote201 views2 answers
S yyyy-MM-dd em vb net
VBA
3 votes196 views1 answer
Vba double quote
VBA
0 vote200 views1 answer
Vba clear collection
VBA
0 vote183 views1 answer
Vba add month to date
VBA
1 vote216 views1 answer
Vb.net get name by Cell Click
VBA
0 vote194 views1 answer
Reset border color textbox vba
VBA
-1 vote178 views1 answer
For i in range vba
VBA
0 vote194 views1 answer
Sort dictionary by key vba
VBA
8 votes409 views1 answer
Vba make a short integer from two bytes
VBA