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