/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 vote145 views1 answer
Vbnet check if string is only symbols
VBA
0 vote135 views1 answer
Find days in month vba
VBA
0 vote178 views1 answer
Vba foreach 2d array
VBA
-1 vote156 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote144 views1 answer
Type excel.application is not defined vb
VBA
0 vote139 views2 answers
Excel vba prevent save
VBA
0 vote157 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote158 views1 answer
Reset border color textbox vba
VBA
0 vote136 views1 answer
Vba dropdown event
VBA
4 votes158 views1 answer
Excel vba how to get a range's full address including sheet name
VBA