Events with diniamically added controls

[fernando]

Hi,

I have an application in VBA were I dinamically add several controls to a
form. Im creating arrays of variables of type Control to access the added
controls, for ex:

Set ctrl_graph(i) = page_id.Controls.Add(add_chkbox_string, "ctrl_graph" & i)

Now I need to add events to this controls, but I have encountered that
'WithEvents' doesnt work with arrays. How can I add events to this controls?

Greetings
Fernando

 

[Tom Ogilvy]

Take a look here - I think the technique used there will apply.

http://www.j-walk.com/ss/excel/tips/tip44.htm
John Walkenbach's site.

 

[fernando]

Tom,

This code works fine, but only with comboboxes, im using also textboxes and
checkboxes, if I define in the class module this:

Public WithEvents ctrl As CheckBox

I get "the object doesnt have automation events", hope the translation is ok.

fernando

 

[fernando]

can the controls events, props and methods be 'inherited'?, for ex. top,
caption, setfocus, etc.

 

[fernando]

Finally got it!

Take a look here - I think the technique used there will apply.

http://www.j-walk.com/ss/excel/tips/tip44.htm
John Walkenbach's site.