/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

-1 vote169 views2 answers
How close excel through visual basic
VBA
0 vote183 views1 answer
Excel protect cells with formulas
VBA
0 vote200 views1 answer
Vba parameter adodb null value
VBA
3 votes191 views1 answer
Vba http request json
VBA
1 vote213 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote173 views1 answer
Excel vba disable copy paste
VBA
1 vote224 views1 answer
Perform http request in vb.net
VBA
0 vote193 views1 answer
Not allow form to be resized
VBA
0 vote207 views1 answer
Vba ternary
VBA
0 vote198 views1 answer
Vba remove numbers from string
VBA