Detect changes to a userform

[Bagharmin]

I have a userform with multiple textboxes, optionbuttons, checkboxes, etc. When a user closes the userform, I want to be able to tell whether any changes were made. Is there a simple way to do this or am I going to have to go through each object one at a time to see if it was changed?

Thanks.

 

[Jaafar Tribak]

See if this works for you:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    If CanUndo Then MsgBox "Changes were made to the userform"
End Sub

 

[Bagharmin]

Worked like a charm! Thank you very much.