/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 vote231 views1 answer
Convert unix to date vba
VBA
0 vote231 views1 answer
Excel vba open browser
VBA
1 vote226 views1 answer
Add rows to datagridview vb.net
VBA
3 votes227 views1 answer
Extract the nth word from a text string
VBA
0 vote242 views1 answer
How to make a a msgbpx in vbs
VBA
5 votes239 views1 answer
Excel-vba get integer high byte
VBA
1 vote224 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
5 votes246 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote213 views1 answer
Add items to combobox vb.net
VBA
2 votes209 views2 answers
Excel vba copy values range to another range
VBA