VBA Code Help

[gnaga]

Hi,

I am writing a macro involves a user form. I am adding the controls like command button,textbox in run time. Now my problem is how to write the procedure for the events of that added controls.

I know how to write event procedure for the control's added in design time.

Thanks

GNaga

 

[stevebausch]

I have programmatically created arrays of controls, in my case, the controls was assigned as listboxes.

But, you won't get events for them. Sorry.

In my case, all the listboxes were to share the same location on the form, and only one was going to be .visible at any moment.

So, in order to have events, I set up a "proxy" control; that control shares the various property assignments of the invisible array element. The proxy control events updates the hidden control. It works well.

In your case, it doesn't seem that having a proxy will do you much good.

 

[gnaga]

Thanks Steave. It looks very hard to do. As Andrew suggested I may have to add controls in design time. Thanks for all you guys.

GNaga

 

[Andrew Poulsom]

In the VBIDE the CodeModule Object has a CreateEventProc Method, which purports to create an event procedure. I say purports because Excel crashed when I tried to use it.