/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 vote199 views1 answer
Vba remove numbers from string
VBA
0 vote226 views1 answer
Weekday vba
VBA
0 vote218 views1 answer
Vba collection contains
VBA
5 votes237 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote217 views1 answer
String contins in vba
VBA
3 votes228 views1 answer
Vba continue for each loop
VBA
0 vote217 views1 answer
Vbnet revrese the order of character in string
VBA
3 votes218 views1 answer
Vba make long from two words
VBA
0 vote246 views1 answer
Vb ternary
VBA
0 vote230 views1 answer
Excel filter by date not working vba
VBA