/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 vote255 views1 answer
Vba random number
VBA
-1 vote253 views1 answer
Code for reading letters only in vb 6
VBA
0 vote271 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote241 views1 answer
Vba check if class implements interface
VBA
0 vote221 views1 answer
Excel vba concatenate range
VBA
0 vote245 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote270 views1 answer
Set datetimepicker value to null vb
VBA
0 vote245 views1 answer
Excel vba unmerge sheet
VBA
3 votes250 views1 answer
Vba post request json
VBA
0 vote292 views2 answers
Excel vba store array and write to sheet
VBA