/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 vote232 views1 answer
How to make a if statement with vbs
VBA
0 vote228 views1 answer
Excel vba StartUpPosition
VBA
1 vote232 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote226 views1 answer
Remove last 8 characters from string vb
VBA
0 vote238 views1 answer
Vba type
VBA
0 vote232 views1 answer
String contins in vba
VBA
0 vote250 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote258 views1 answer
Vbscript Trim
VBA
0 vote346 views2 answers
VB
VBA
0 vote304 views1 answer
Find control with name vb
VBA