/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 vote326 views1 answer
Vba argument is set
VBA
0 vote314 views1 answer
Excel vba populate array with cell values
VBA
0 vote335 views1 answer
Vbnet get file name from path
VBA
1 vote333 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote339 views1 answer
String contins in vba
VBA
0 vote337 views1 answer
Vbnet add axis labels to chart
VBA
1 vote325 views1 answer
How to do error handling in access vba
VBA
0 vote334 views1 answer
Excel vba join variant array
VBA
0 vote343 views2 answers
Excel vba copy paste after last row
VBA
0 vote355 views1 answer
Columns dont autoresize on program start vb.net
VBA