/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 vote233 views1 answer
Excel vba prevent saving workbook
VBA
0 vote213 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote231 views1 answer
Excel vba round to whole number
VBA
-1 vote206 views2 answers
How close excel through visual basic
VBA
0 vote225 views1 answer
Regex numeric digits
VBA
0 vote228 views1 answer
Excel VBA web scraping
VBA
0 vote219 views1 answer
Excel vba hide gridlines
VBA
0 vote208 views1 answer
Vba type variable
VBA
0 vote236 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote227 views1 answer
Excel vba protect worksheet without password
VBA