Error 459 in Excel - no Implements - no WithEvents

[laurent.vanroy]

Hello,

I have a developed a complex .xla.

Since the beginning of the week, when I start one of the forms I
receive a 459 error "Objet or Class does not support the set of
events".

I've read the help, posts on usenet and checked the following points:
- WithEvents: only one class with one WithEvents and one instance of
this class. I removed the "WIthEvents" for the tests,
- Implements: None
- Arrays of controls: Not available in VBA (only a VB feature?)
- Objects as Sub parameters: One UserForm Sub with one _Object_
parameter (I use it to pass a TextBox Control). I removed it too.

All the Modules have the _Option Explicit_. It compiles successfully.

The message occurs whenever I start that form and only that form. A
breakpoint on the UserForm_Initialize doesn't help to see what is the
problem.

Actually, I have done no modifications to the code! Thus it should be
related to an external cause, like (des)installation of other programs.
Does this sound logical ?

I would greatly appreciate any clue about that, any lead, ...
Thanks
Laurent

 

[Steve Jorgensen]

Did you install Windows XP Service Pack 2 at the beginning of the week? I
understand that can affect VBA applications trying to access external code.

 

[Laurent van Roy]

Did you install Windows XP Service Pack 2 at the beginning of the week? I

understand that can affect VBA applications trying to access external code.

No I haven't. I'm working under W2K, SP4.

To what may this problem by related ?

 

[laurent.vanroy]

I solved my problem: this how:

On the "Additional Controls" window (from the Toolbox palette in VBA),
I had several controls with no name. I re-registred the corresponding
OCX with REGSVR32.EXE.

Now it works fine again.

This may be due to some background installation.
I hope this helps the next one to have this problem.

Laurent