| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| handle error in IF ELSEIF statement | Excel Worksheet Functions | |||
| How do I handle error conditions with the FIND command? | Excel Worksheet Functions | |||
| How to make error handle for mis-typed variable? | Excel Programming | |||
| Out of memory error | Excel Programming | |||
Hybrid Mode
