/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

5 votes137 views1 answer
Excel vba left word from Long Integer
VBA
0 vote123 views1 answer
How to format a textbox as date vb net
VBA
1 vote141 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote129 views1 answer
Compare dates vb
VBA
1 vote124 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote120 views1 answer
Vba word pdf table to excel
VBA
0 vote135 views1 answer
Excel vba hide gridlines
VBA
0 vote128 views1 answer
Vb window.minimize
VBA
0 vote138 views1 answer
Vbscript Trim
VBA
5 votes148 views1 answer
Vba low byte from INTEGER
VBA