Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing multiple duplicate events Father John Excel Worksheet Functions 10 April 13th 10 11:24 AM
Multiple change events on same sheet JG Scott Excel Programming 4 January 19th 06 03:56 AM
Multiple change events on same sheet JG Scott Excel Programming 0 November 30th 05 01:45 PM
Instancing on Classmodule on Excel 2002 Tetsuya Oguma[_4_] Excel Programming 2 August 10th 04 12:11 AM
Can I create in VBA a class with instancing type different from 1 and 2? Dmitry V. Petkun Excel Programming 2 November 4th 03 05:31 PM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"