How to handle error 8007000e Memory Error
 

Hi

When I click on a userform commandbutton for the 2nd time, the following
error appears:

Run-time error '-2147024882 (8007000e)Not enough storage is available to
complete the operation'

Thanks for suggestions

Luis

How to handle error 8007000e Memory Error
 

Has the code terminated from the first time you clicked the button?

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi

When I click on a userform commandbutton for the 2nd time, the following
error appears:

Run-time error '-2147024882 (8007000e)Not enough storage is available to
complete the operation'

Thanks for suggestions

Luis

How to handle error 8007000e Memory Error
 

Hi Tom, yeah, the first time that I click the commandbutton everything is ok
(The first time the procedure is ligthly different to the second time).
Curiosly, it happens only with the procedure linked to this button.

Thanks for your help

Luis


"Tom Ogilvy" escribió en el mensaje
...
Has the code terminated from the first time you clicked the button?

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi

When I click on a userform commandbutton for the 2nd time, the following
error appears:

Run-time error '-2147024882 (8007000e)Not enough storage is available to
complete the operation'

Thanks for suggestions

Luis

How to handle error 8007000e Memory Error
 

If you unload and show the original userform or show another userform and
that userform shows the original useform perhaps based on a button click,
then your routine may not have ended as you think it has.

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi Tom, yeah, the first time that I click the commandbutton everything is
ok
(The first time the procedure is ligthly different to the second time).
Curiosly, it happens only with the procedure linked to this button.

Thanks for your help

Luis


"Tom Ogilvy" escribió en el mensaje
...
Has the code terminated from the first time you clicked the button?

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi

When I click on a userform commandbutton for the 2nd time, the
following
error appears:

Run-time error '-2147024882 (8007000e)Not enough storage is available
to
complete the operation'

Thanks for suggestions

Luis

How to handle error 8007000e Memory Error
 

Hello Tom, the commandbutton doesn't show any aditional userform. Only it
execute a VBA procedure opnening other workbooks.

Luis

"Tom Ogilvy" escribió en el mensaje
...
If you unload and show the original userform or show another userform and
that userform shows the original useform perhaps based on a button click,
then your routine may not have ended as you think it has.

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi Tom, yeah, the first time that I click the commandbutton everything is
ok
(The first time the procedure is ligthly different to the second time).
Curiosly, it happens only with the procedure linked to this button.

Thanks for your help

Luis


"Tom Ogilvy" escribió en el mensaje
...
Has the code terminated from the first time you clicked the button?

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi

When I click on a userform commandbutton for the 2nd time, the
following
error appears:

Run-time error '-2147024882 (8007000e)Not enough storage is available
to
complete the operation'

Thanks for suggestions

Luis

How to handle error 8007000e Memory Error
 

Not sure what to tell you then. Maybe you need to close them after you use
them.

Make sure any sheets have their zoom levels set to 100% can sometimes help.

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hello Tom, the commandbutton doesn't show any aditional userform. Only it
execute a VBA procedure opnening other workbooks.

Luis

"Tom Ogilvy" escribió en el mensaje
...
If you unload and show the original userform or show another userform
and
that userform shows the original useform perhaps based on a button
click,
then your routine may not have ended as you think it has.

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi Tom, yeah, the first time that I click the commandbutton everything
is
ok
(The first time the procedure is ligthly different to the second time).
Curiosly, it happens only with the procedure linked to this button.

Thanks for your help

Luis


"Tom Ogilvy" escribió en el mensaje
...
Has the code terminated from the first time you clicked the button?

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi

When I click on a userform commandbutton for the 2nd time, the
following
error appears:

Run-time error '-2147024882 (8007000e)Not enough storage is
available
to
complete the operation'

Thanks for suggestions

Luis

How to handle error 8007000e Memory Error
 

There's no any information in MSKnowledgeBase about this error occurred
specificly in Excel. The solution is to include a procedure that unload a
load the userform, each time you click on it.

Luis

"Tom Ogilvy" escribió en el mensaje
...
Not sure what to tell you then. Maybe you need to close them after you
use
them.

Make sure any sheets have their zoom levels set to 100% can sometimes
help.

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hello Tom, the commandbutton doesn't show any aditional userform. Only
it
execute a VBA procedure opnening other workbooks.

Luis

"Tom Ogilvy" escribió en el mensaje
...
If you unload and show the original userform or show another userform
and
that userform shows the original useform perhaps based on a button
click,
then your routine may not have ended as you think it has.

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi Tom, yeah, the first time that I click the commandbutton
everything
is
ok
(The first time the procedure is ligthly different to the second
time).
Curiosly, it happens only with the procedure linked to this button.

Thanks for your help

Luis


"Tom Ogilvy" escribió en el mensaje
...
Has the code terminated from the first time you clicked the button?

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi

When I click on a userform commandbutton for the 2nd time, the
following
error appears:

Run-time error '-2147024882 (8007000e)Not enough storage is
available
to
complete the operation'

Thanks for suggestions

Luis