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"
wrote in message
I have to attach a code with vba that will open my userform when you click my
command button. Help please