View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default UserForm Error 459

Start by making sure you have Option Explicit at the top of every module
(including forms and classes) and then see if it still compiles. This is
with
Debug, Compile. If it doesn't then it may point you in the right direction.

RBS

"Jimmah" wrote in message
oups.com...
Hi there,
I've written a Excel application that utilises a UserForm (containing
a TreeView, buttons, etc). On all machines I have tested this on this
works, but one machine doesn't.

The application references Microsoft Common Controls 6.0 (SP6), and
this is the same file on all machines.

When I try hit the command UserForm.Show on the machine that doesn't
work I get the ominous:
"Error '459' Object or Class does not support this set of events".

I looked at the help for this, and it talks about Implementing and
WithEvents, neither of which have been used.

Does anyone have any idea what causes this error?

Thanks,
James Simm