/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 vote241 views1 answer
Find if year is leap year vb
VBA
1 vote230 views1 answer
If inputbox cancel vba
VBA
-1 vote287 views1 answer
Vba sendkeys
VBA
5 votes245 views1 answer
Excel vba left word from Long Integer
VBA
0 vote247 views1 answer
Build an index all files of a FTP site
VBA
0 vote263 views1 answer
Vbnet check if string is only letters
VBA
0 vote248 views1 answer
Excel vba paste all to each sheet in workbook
VBA
1 vote229 views1 answer
Excel vba close form escape key
VBA
0 vote230 views1 answer
Priavte sub with multiple handels find sneder
VBA
5 votes263 views1 answer
Vba low byte from INTEGER
VBA