eventhandling of dynamically created form components

[Nixxman]

Hello everybody,
after a few hours of googling i decided to ask for help.

Im writing a VBA macro/application (excel 2003) where i dynamically generate components on form. What i need is to handle events (change) of checkbox. I found an perfect example, but it is for ComboBox. Converting to checkbox is severe problem for me.. After trying to change combox to checkbox i get error:

Compile error:
Object does not source automation events

Perfectly working source is following - when replacing two lines by commented ones, i keep gettin error mention above.

Option Explicit
 
 Dim WithEvents cboNew As ComboBox
'Dim WithEvents cboNew As CheckBox
 
Private Sub CommandButton1_Click()
 
'Set cboNew = Controls.Add("Forms.CheckBox.1", "cboNew")
 Set cboNew = Controls.Add("Forms.ComboBox.1", "cboNew")
 
End Sub
 
Private Sub cboNew_Change()
    MsgBox "Dynamically created form component has changed."
End Sub

[michelxld]

Hi,

Replace

Dim WithEvents cboNew As CheckBox

by

Dim WithEvents cboNew As msforms.CheckBox

Regards
michel