LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
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








 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
handle error in IF ELSEIF statement Sabosis Excel Worksheet Functions 1 April 30th 09 05:06 AM
How do I handle error conditions with the FIND command? mywebaccts (at) PLUGcomcast.net Excel Worksheet Functions 6 August 5th 07 12:14 AM
How to make error handle for mis-typed variable? RB Smissaert Excel Programming 22 May 1st 05 10:33 PM
Out of memory error Francesco Guiseppe Linguine Excel Programming 4 August 3rd 04 01:49 PM


All times are GMT +1. The time now is 11:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"