/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 vote346 views1 answer
Vba len variant
VBA
3 votes354 views1 answer
Excel vba get the workbook full file name with path
VBA
1 vote354 views1 answer
VBA Loop through recordset
VBA
1 vote372 views2 answers
Get all column names from excel vba
VBA
0 vote366 views2 answers
Checking and changing system volume vb.net
VBA
4 votes343 views2 answers
Vba array length
VBA
3 votes360 views1 answer
Extract the nth word from a text string
VBA
0 vote326 views1 answer
Excel vba formatconditions range
VBA
0 vote355 views1 answer
Vba leading zeros in string
VBA
0 vote338 views1 answer
Excel vba disable mouse click
VBA