/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 vote313 views1 answer
Vbs run
VBA
0 vote307 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
3 votes314 views1 answer
Extract the nth word from a text string
VBA
2 votes310 views1 answer
Vba split string
VBA
8 votes467 views1 answer
Excel vba make word from bytes
VBA
0 vote320 views1 answer
Vba cell all borders
VBA
0 vote297 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote323 views1 answer
Rotate image by any angle vb.net
VBA
0 vote307 views1 answer
Default host vbox address
VBA
0 vote355 views1 answer
Vba userform textbox wrap text
VBA