View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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