/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 vote292 views1 answer
Vba remove the first character of string
VBA
0 vote263 views1 answer
Visual basic msdos
VBA
0 vote283 views1 answer
Vba add spaces
VBA
0 vote266 views1 answer
Excel vba center userform
VBA
3 votes263 views1 answer
Vba make long from two shorts
VBA
0 vote288 views1 answer
Excel named range sum
VBA
0 vote264 views1 answer
Vba line feed
VBA
0 vote267 views1 answer
Excel vba automatic calculation
VBA
0 vote271 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote268 views1 answer
Vbnet line graph smooth lines
VBA