The Code that a CommandButtopn runs should be in the Commandbutton_Click() Sub, Unless you need it to run with Other Controls. It should only be ina Module if it will be used outside the UserForm
CBut Code
Multi Form Control CodeSub CButton1_Click() Code from text3 Here End Sub
MultiUse CodeSub CButton1_Click() Text3 End Sub 'UserFormCode: Sub text3() blahblah End Sub
'UserForm Code Sub CButton1_Click() Module1.text3 End Sub




Reply With Quote