loading dynamic controls in a excel VBA form ?

[JohanJohansson]

How is this done in Excel VBA ?

Private Sub UserForm_Initialize()

Controls.Add("VB.CheckBox", "chbCheckBox&quot

End Sub

This works for VB6 but not for VBA for me ?

/Johan

 

[msmith]

Johan,

try the following:

Controls.Add("Forms.CheckBox.1", "chbCheckBox")

HTH
M. Smith