Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've created a class code were all OLEobjects embedded on the worksheet are
group by type and then used to trigger events in this "Class Code". On the spinbuttons the SpinUp & SpinDown event all have the class code Instance twice (run twice on one press) all other events only instance once (run once) Any thoughts as to why this could occur? Ben -- When you lose your mind, you free your life. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
for anyone who reads this with the same problem,
when the event triggered the macro, it was coded to re-instance itself, which looped the code into more than one instance sigh Ben -- When you lose your mind, you free your life. "ben" wrote: I've created a class code were all OLEobjects embedded on the worksheet are group by type and then used to trigger events in this "Class Code". On the spinbuttons the SpinUp & SpinDown event all have the class code Instance twice (run twice on one press) all other events only instance once (run once) Any thoughts as to why this could occur? Ben -- When you lose your mind, you free your life. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing multiple duplicate events | Excel Worksheet Functions | |||
Multiple change events on same sheet | Excel Programming | |||
Multiple change events on same sheet | Excel Programming | |||
Instancing on Classmodule on Excel 2002 | Excel Programming | |||
Can I create in VBA a class with instancing type different from 1 and 2? | Excel Programming |