View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ordnance1[_2_] ordnance1[_2_] is offline
external usenet poster
 
Posts: 92
Default UserForm_Terminate problem

Can anyone explain to me why, when I run the code below by clicking on my
Cancel Button or the Red X on my Userform every thing works fine, but the
next time the UserForm is called clicking on the Cancel Button or the Red X
nothing happens. The UserForm does not close nor does the rest of the code
run. For that matter nothing on the UserForm works (there are other
CommandButtons with code attached to them).

Private Sub UserForm_Terminate()

Unload EmployeeList

Application.ScreenUpdating = True
Range("A3").Select
msgbox "QueryClose"
Unload EmployeeList
Module6.StartTimer

End Sub