/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 vote186 views1 answer
Iterate all file in a folder vba
VBA
1 vote161 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote175 views1 answer
Build an index all files of a FTP site
VBA
0 vote256 views1 answer
Find the name of the last excel sheet vb
VBA
1 vote159 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote158 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote159 views1 answer
Vba change named range address
VBA
0 vote178 views1 answer
Visual stuiod not recognising desgined labels
VBA
5 votes168 views1 answer
Xl vba double quotes in string literal
VBA
0 vote188 views1 answer
Search for text in every worksheet excel visual basic
VBA