View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default What code do I use to attach event handler that will open my user.


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