Close Button Error

[Guest]

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!!

 

[Guest]

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.

 

[Guest]

Unfortunately, "Debug" doesn't come up for this particular error. The only
options are "OK" and "Help".

-Allen

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.

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!!

 

[Guest]

hmm...

Try looking at the code for the userform on your own. Check to see if you
have any of the following userform events:
Deactivate
QueryClose
Terminate

never a bad idea to post any code you have on the Userform so that we can
take a look at what might be causing the problem

Unfortunately, "Debug" doesn't come up for this particular error. The only
options are "OK" and "Help".

-Allen

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.

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!!

 

[Guest]

Problem Solved.

Private Sub UserForm1_Initialize()

Application.Visible = False
UserForm1.Show '<==== There was my problem...

End Sub

You don't have to tell it to show the userform, it automatically shows,
because I call it in my Workbook_Open() line of code. So, everytime I tried
closing the box, it would go against the userform1.show... causing an error.
Good to know! Thanks!

-Allen

Unfortunately, "Debug" doesn't come up for this particular error. The only
options are "OK" and "Help".

-Allen

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.

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!!