Thread: Form Actions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
phil phil is offline
external usenet poster
 
Posts: 201
Default Form Actions

Hi,

I have 2 forms on the first form is a button which saves the current work
book, unloads the form and then opens the second form. The problem is when I
click the first button the form does not shut and the second one opens over
the top and when you click the button on the second form to shut it the whole
thing crash's can someone help, here is code I am using

Button One

Private Sub Finnish_Click()
ActiveWorkbook.Save
ActiveWorkbook.SaveAs Filename:="C:\Questionaire.xls"
Unload Me
UserForm3.Show
End Sub

Button Two

Private Sub UserForm_Click()

Unload Me
End Sub


Thanks