| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Events on controls generated on the fly...
Hi there,
I have this sub that inserts some opition_buttons in my form... Sub AddOption(pag As Integer) Dim c As Control Set c = MultiPage1.Pages(pag).Controls.Add("Forms.OptionBu tton.1", "option", Visible) c.Caption = "Option:" c.Height = 20 c.Width = 100 c.Left = -50 c.Top = 5 + ((c.Top + c.Height) * CountOptionsInForm) c.Visible = True c.Tag = CountOptionsInForm End Sub is there a way to code events for those controls? I just need to handle the _change or the _click method... Thanks, ste |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Events on controls generated on the fly...
Here's some good info http://www.cpearson.com/excel/vbe.htm "ste" schreef in bericht ups.com... Hi there, I have this sub that inserts some opition_buttons in my form... Sub AddOption(pag As Integer) Dim c As Control Set c = MultiPage1.Pages(pag).Controls.Add("Forms.OptionBu tton.1", "option", Visible) c.Caption = "Option:" c.Height = 20 c.Width = 100 c.Left = -50 c.Top = 5 + ((c.Top + c.Height) * CountOptionsInForm) c.Visible = True c.Tag = CountOptionsInForm End Sub is there a way to code events for those controls? I just need to handle the _change or the _click method... Thanks, ste |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning events to runtime-created controls - is it possible? | Excel Discussion (Misc queries) | |||
| Events for controls created on the fly on a userform | Excel Programming | |||
| Add Controls With Events at Runtime | Excel Programming | |||
| Events for Controls in a Multipage Control | Excel Programming | |||
| Trapping Events generated by a Worksheet | Excel Programming | |||
Linear Mode
