I've created a worksheet that has a number of control toolbox objects on it.
When the Initialize Events macro starts I create events for each object in
the main module that works with a class module.

During run time, I create new form objects on the worksheet. Now I want to
create events for the new objects and add them to the events collection that
I created when the Initialize Events macro ran.

How can I code this so that the new events and old events will both work
during run time?

Thanks

Steve

The objects are being placed into cells depending on the value of the cells.
The cells are used for objects in some cases, textual values in others, and
blank in others.

Steve

"OssieMac" wrote:

Hi Steve,

It looks to me like you are making life hard for yourself but perhaps there
is a good reason for adding event code and objects on the run.

Is there any good reason why you can't create all of the objects and add the
code in the interactive mode and then just set the visible property to false
until you require them? Unless there is a reason why you can't do it that way
then the problems associated with creating them within your code are not
worth it.


--
Regards,

OssieMac


"sarndt" wrote:

I've created a worksheet that has a number of control toolbox objects on it.
When the Initialize Events macro starts I create events for each object in
the main module that works with a class module.

During run time, I create new form objects on the worksheet. Now I want to
create events for the new objects and add them to the events collection that
I created when the Initialize Events macro ran.

How can I code this so that the new events and old events will both work
during run time?

Thanks

Steve