/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 vote300 views1 answer
Vba listindex select multiple items vba
VBA
0 vote329 views1 answer
Remove series name from legendvbnet
VBA
4 votes331 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote320 views1 answer
Visual stuiod not recognising desgined labels
VBA
1 vote359 views1 answer
How to put a gridpain in a vbox
VBA
0 vote330 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote331 views1 answer
Vba sort multiple columns
VBA
2 votes361 views2 answers
Excel vba if sunday or staurday
VBA
3 votes327 views1 answer
Vba make long from two shorts
VBA
0 vote344 views1 answer
Check if cell is dbnullvb.net
VBA