![]() |
Multiple Instancing of certain events
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. |
Multiple Instancing of certain events
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. |
All times are GMT +1. The time now is 10:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com