|
Unbelievable error 457
Hello All !
VBA XL 2003 Is there any Guru who could help solving this : I have a UserForm in a small app who used to work properly until yesterday. Suddenly, I cannot either show, unload, hide, read textboxes option buttons etc. with this UF. It raise the 457 error. Same behaiour in the immediate window of the VBE. Since I don't have any collection running at this time, I really don't understand. It seems like it is an internal collection of objects in VBA Excel (?) that is faulty. I have been programming VBA since more than 12 years and I never saw that before ! Any help, tips or tricks would be highly appreciated. Thank you beforehand. Patrick |
Unbelievable error 457
Post the code and show where the error occurs?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Patrick Penet" wrote in message ... Hello All ! VBA XL 2003 Is there any Guru who could help solving this : I have a UserForm in a small app who used to work properly until yesterday. Suddenly, I cannot either show, unload, hide, read textboxes option buttons etc. with this UF. It raise the 457 error. Same behaiour in the immediate window of the VBE. Since I don't have any collection running at this time, I really don't understand. It seems like it is an internal collection of objects in VBA Excel (?) that is faulty. I have been programming VBA since more than 12 years and I never saw that before ! Any help, tips or tricks would be highly appreciated. Thank you beforehand. Patrick |
Unbelievable error 457
Hello Patrick
I too have experienced this before. Only alternative found: Export every component of the VBA Project into a fresh new workbook. Bon courage ;-) Cordially Pascal "Patrick Penet" a écrit dans le message de news: ... Hello All ! VBA XL 2003 Is there any Guru who could help solving this : I have a UserForm in a small app who used to work properly until yesterday. Suddenly, I cannot either show, unload, hide, read textboxes option buttons etc. with this UF. It raise the 457 error. Same behaiour in the immediate window of the VBE. Since I don't have any collection running at this time, I really don't understand. It seems like it is an internal collection of objects in VBA Excel (?) that is faulty. I have been programming VBA since more than 12 years and I never saw that before ! Any help, tips or tricks would be highly appreciated. Thank you beforehand. Patrick |
Unbelievable error 457
Bonjour Pascal,
If this the only way to get rid of this I'll do it. :-(((( Before I would try to copy the whole stuff of the UF into a new one, and let you know... Merci pour l'idée - Thanks for the idea. Patrick "papou" a écrit dans le message de news: ... Hello Patrick I too have experienced this before. Only alternative found: Export every component of the VBA Project into a fresh new workbook. Bon courage ;-) Cordially Pascal "Patrick Penet" a écrit dans le message de news: ... Hello All ! VBA XL 2003 Is there any Guru who could help solving this : I have a UserForm in a small app who used to work properly until yesterday. Suddenly, I cannot either show, unload, hide, read textboxes option buttons etc. with this UF. It raise the 457 error. Same behaiour in the immediate window of the VBE. Since I don't have any collection running at this time, I really don't understand. It seems like it is an internal collection of objects in VBA Excel (?) that is faulty. I have been programming VBA since more than 12 years and I never saw that before ! Any help, tips or tricks would be highly appreciated. Thank you beforehand. Patrick |
Unbelievable error 457
Before I would try to copy the whole stuff of the
UF into a new one, and let you know... This does'nt work ... Export every component of the VBA Project into a fresh new workbook This does'nt work either ... I'm out of idea. :-((((( Patrick "Patrick Penet" a écrit dans le message de news: ... Bonjour Pascal, If this the only way to get rid of this I'll do it. :-(((( Before I would try to copy the whole stuff of the UF into a new one, and let you know... Merci pour l'idée - Thanks for the idea. Patrick "papou" a écrit dans le message de news: ... Hello Patrick I too have experienced this before. Only alternative found: Export every component of the VBA Project into a fresh new workbook. Bon courage ;-) Cordially Pascal "Patrick Penet" a écrit dans le message de news: ... Hello All ! VBA XL 2003 Is there any Guru who could help solving this : I have a UserForm in a small app who used to work properly until yesterday. Suddenly, I cannot either show, unload, hide, read textboxes option buttons etc. with this UF. It raise the 457 error. Same behaiour in the immediate window of the VBE. Since I don't have any collection running at this time, I really don't understand. It seems like it is an internal collection of objects in VBA Excel (?) that is faulty. I have been programming VBA since more than 12 years and I never saw that before ! Any help, tips or tricks would be highly appreciated. Thank you beforehand. Patrick |
| All times are GMT +1. The time now is 09:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com