/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 votes248 views1 answer
Vba low byte from INTEGER
VBA
0 vote186 views1 answer
Vba code to remove leading and trailing spaces
VBA
6 votes254 views1 answer
Excel vba isalpha
VBA
-1 vote255 views1 answer
Text to speech vb.net
VBA
0 vote218 views1 answer
Vb net check if file exists
VBA
0 vote212 views1 answer
Excel protect cells with formulas
VBA
3 votes260 views2 answers
Vba date to string
VBA
0 vote250 views1 answer
Vba sort multiple columns
VBA
5 votes170 views1 answer
Vlookup vba
VBA
0 vote239 views1 answer
How to get the value of optionbutton in vba
VBA