Unbelievable error 457

[Patrick Penet]

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

 

[Bob Phillips]

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]

There is no error in the code at all.
Even a simple line like UFProduct.Show would throw
error 457 !!

uhh ??
:-(
Patrick

 

[papou]

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]

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

 

[Patrick Penet]

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