Okay -- I never thought about events and screenupdating before. I know it's
tangential to you initial concern, but after reading your post I tried a few
things and realize I don't understand how screenupdating is controlled --
maybe you know?

When you mentioned that you get flickers because you need events I figured
that you couldn't turn off updating and still get your events. (I may have
completely misunderstood, and you were considering turning off events.)
Anyway, I wrote a small progam to set screenupdating=false. Then put an
SelectionChange event in a worksheet to add the value of screenupdating to a
collection (didn't want to mess it up with a msgbox). This was followed by a
stop.

I looked at the collection (in the immediate pane) and saw that
screenupdating had been turned to true. I did check by add it's status to
the collection immediately after setting it (in a macro in a module).

Do you know how this works? Does an event being triggered automatically
turn it back on? Aren't you sorry you put in that gratuitous information?
<g.



"Nik" wrote:

I'm not sure if this is what you want. You probably need to set up a
collection to hold the instances of your class -- this needs to be set up in
a module -- not a class module. See the following:

Aah, thanks. That was what I was looking for. Too bad events have to
be enabled for it to work so
there is some flickering but at least it works.