| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
| run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
| Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Hybrid Mode
