/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

2 votes158 views1 answer
Vba file from path
VBA
0 vote164 views1 answer
Excel vba set cell value to empty
VBA
0 vote170 views1 answer
Excel vba paste all to each sheet in workbook
VBA
25 votes291 views3 answers
String to date vb
VBA
2 votes146 views1 answer
Excel vba extract file name
VBA
8 votes238 views1 answer
Excel vba determine number of elements in a 1D array
VBA
1 vote146 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote146 views1 answer
Test if form is open vb
VBA
1 vote146 views1 answer
Excel vba hide zero values
VBA
0 vote156 views1 answer
Excel vba copy entire sheet paste values
VBA