Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Error 459
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform Error | Excel Programming | |||
userform error | Excel Programming | |||
error in userform | Excel Discussion (Misc queries) | |||
userform error | Excel Programming | |||
userform error | Excel Programming |