/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 vote176 views1 answer
Compare dates vb
VBA
3 votes199 views1 answer
Excel vba get the workbook full filename with path
VBA
15 votes275 views1 answer
Excel vba wait
VBA
0 vote211 views1 answer
Vbnet check if string is only letters
VBA
0 vote181 views1 answer
Vba collection key list
VBA
0 vote183 views1 answer
Vba word open document read only
VBA
1 vote184 views1 answer
Excel vba last row of range
VBA
0 vote207 views1 answer
Vba cell all borders
VBA
0 vote181 views1 answer
Loop through lines in text file vb net
VBA
0 vote222 views1 answer
Vba userform textbox wrap text
VBA