User-defined type error

[rjplante]

I have a workbook that I have been using and I am running into an error when I run the macro that executes on close. I get the following error: "User-defined type not defined." My VBA window appears when this error pops up and then when I click on the ok button, it returns me to the excel window of my workbook. When I go to the VBA window again no, code window is displayed and no code line is highlighted which would indicate where I should look to repair my code.

What can I do to remedy this issue?

Thanks

Robert

 

[rjplante]

Nothing is listed as being missing. Still at a loss as to how to find what is causing the error to appear. I have checked the break on all errors and still no line of code gets highlighted when the message appears. I am thoroughly confused. I have removed the code below which was implemented to disable the red close box on my user forms. My error started appearing after I made this change. I have the code still there, just with the comment indicator ( ' ) in front of it to disable the code. This has not corrected my problem. I will look for another way to make this change and see if it still remains.

Thanks for all the help. Wish I were smarter.

Private Sub UserForm_QueryClose(Cancel As Integer, _
  CloseMode As Integer)
  If CloseMode = vbFormControlMenu Then
    Cancel = True
    MsgBox "Please select the CANCEL button on the form!"
  End If
End Sub

[\code]

 

[RoryA]

You haven't posted all of your code, but I do note that in your userform1 code you have:

Activeworbook.Save

which should be:

Activeworkbook.Save