I'm using Excel 2003 with XP.
Is there a way to trap the close event when a user clicks on the red "X" box
in the upper right corner of a Userform?
Thanks,
Bert

Look at the QueryClose event in help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bert" wrote in message
...
I'm using Excel 2003 with XP.
Is there a way to trap the close event when a user clicks on the red "X"
box in the upper right corner of a Userform?
Thanks,
Bert