/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 vote219 views1 answer
Find database connection string vb
VBA
0 vote203 views1 answer
Excel vba send HTTP POST to server
VBA
3 votes199 views1 answer
Excel vba read registry key value
VBA
1 vote214 views1 answer
Excel vba get column number from column name
VBA
0 vote209 views1 answer
Vba sheet hide unhide
VBA
0 vote219 views1 answer
Vbs run with cscript
VBA
0 vote220 views1 answer
Excel vba named range exists
VBA
0 vote201 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
15 votes421 views1 answer
Excel vba wait
VBA
0 vote225 views1 answer
Excel vba DisplayAlerts
VBA