ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple Instancing of certain events (https://www.excelbanter.com/excel-programming/348005-multiple-instancing-certain-events.html)

ben

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.

ben

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