/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

5 votes485 views1 answer
Vlookup vba
VBA
2 votes162 views1 answer
Vba uppercase first letter of each word
VBA
0 vote161 views1 answer
Excel vba linter
VBA
0 vote180 views1 answer
Regex numeric digits
VBA
0 vote176 views1 answer
Excel vba copy range with filter
VBA
1 vote173 views1 answer
Excel vba get ordinal number from cardinal number
VBA
5 votes122 views1 answer
Vba array worksheet.index
VBA
0 vote163 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote192 views1 answer
Vbs exec hidden
VBA
0 vote163 views1 answer
Vb net check if file exists
VBA