Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multipage, controls-collection and events (XL2003, VBA)
Dear Group,
I have a Userform with a Multipage control, which is dynamically filled with textboxes and comboboxes using Controls.Add like this: Set aTextBox = aUserForm.aMultiPage.Pages(strCurrentRegister).Con trols.Add("Forms.TextBox.1", "txt" & strText, True) Set aComboBox = aUserForm.aMultiPage.Pages(strCurrentRegister).Con trols.Add("Forms.ComboBox.1", "txt" & strText, True) This is working fine, but what I miss is any way to assign eventhandlers. Is there any way to do this? If not, I could use existing controls, which I would create in a sufficient quantity. Here I could prepare eventhandlers. But going this way, how to assign the controls to the Page of Multipage control? I am working with Excel 2003 and VBA. Thanks in advance, Holger. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add New Events to Existing Collection of Events | Excel Programming | |||
XL2003: Is it possible to sink a form's events in a class module ? | Excel Programming | |||
Running procedures on events xl2003 | Excel Programming | |||
Help with Multipage Events | Excel Programming | |||
Events for Controls in a Multipage Control | Excel Programming |