You likely have a userform event that triggers when the form closes that is
causing the error. The [x] should work on its own. When you get the error
message, click debug then see which line of a particular sub is causing the
error. If you can post the code for that sub, we can help you out.

"Allen Geddes" wrote:

Hello,

I've created a UserForm, but seem to be having problems with the
automatically inserted red x close button in the upper right corner of the
UserForm.

When I try and exit my UserForm by using that red X, I get the following
error message:

Run-time error '91':

Object variable or With Block variable not set

Do I need to put in a piece of code to activate the red X button?

something like:

Private sub UserForm_Terminate()

unload me

End Sub


Thank you in advance for your help!!