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

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
news:[email protected]...
> 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
>
>

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" <[email protected]> escribió en el mensaje
news:[email protected]...
> 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
> news:[email protected]...
>> 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
>>
>>
>
>

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
news:[email protected]...
> 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" <[email protected]> escribió en el mensaje
> news:[email protected]...
> > 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
> > news:[email protected]...
> >> 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
> >>
> >>
> >
> >
>
>

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

Luis

"Tom Ogilvy" <[email protected]> escribió en el mensaje
news:[email protected]...
> 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
> news:[email protected]...
>> 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" <[email protected]> escribió en el mensaje
>> news:[email protected]...
>> > 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
>> > news:[email protected]...
>> >> 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
>> >>
>> >>
>> >
>> >
>>
>>
>
>

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
news:%[email protected]...
> Hello Tom, the commandbutton doesn't show any aditional userform. Only it
> execute a VBA procedure opnening other workbooks.
>
> Luis
>
> "Tom Ogilvy" <[email protected]> escribió en el mensaje
> news:[email protected]...
> > 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
> > news:[email protected]...
> >> 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" <[email protected]> escribió en el mensaje
> >> news:[email protected]...
> >> > 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
> >> > news:[email protected]...
> >> >> 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
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>

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" <[email protected]> escribió en el mensaje
news:[email protected]...
> 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
> news:%[email protected]...
> > Hello Tom, the commandbutton doesn't show any aditional userform. Only
it
> > execute a VBA procedure opnening other workbooks.
> >
> > Luis
> >
> > "Tom Ogilvy" <[email protected]> escribió en el mensaje
> > news:[email protected]...
> > > 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
> > > news:[email protected]...
> > >> 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" <[email protected]> escribió en el mensaje
> > >> news:[email protected]...
> > >> > 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
> > >> > news:[email protected]...
> > >> >> 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
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>
>