What code do I use to attach event handler that will open my user.

[TeresaManley]

I have to attach a code with vba that will open my userform when you click my
command button. Help please

 

[Jim Cone]

Private Sub CommandButton1_Click()
UserForm1.Show
Unload UserForm1
End Sub

(it's in the chapter on user forms)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"TeresaManley"
<[email protected]>
wrote in message
I have to attach a code with vba that will open my userform when you click my
command button. Help please

 

[FSt1]

hi.
Sub macShoForm()

Load frmYourForm
frmYourForm.Show 0
AppActivate Application.Caption

End Sub