/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 vote209 views1 answer
Vba sort the data Z to A
VBA
0 vote208 views1 answer
Change form background image vb
VBA
0 vote225 views1 answer
Find if year is leap year vb
VBA
-1 vote238 views1 answer
How save excel through visual basic
VBA
5 votes222 views1 answer
Excel vba left word from Long Integer
VBA
0 vote221 views1 answer
Filesystemobject vba reference
VBA
3 votes235 views1 answer
Extract word in a text in excel
VBA
0 vote204 views1 answer
Vbscript remove spaces from string
VBA
0 vote202 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote215 views1 answer
Excel R1C1 mode
VBA