loading dynamic controls in a excel VBA form ?
loading dynamic controls in a excel VBA form ?
(OP)
How is this done in Excel VBA ?
Private Sub UserForm_Initialize()
Controls.Add("VB.CheckBox", "chbCheckBox")
End Sub
This works for VB6 but not for VBA for me ?
/Johan
Private Sub UserForm_Initialize()
Controls.Add("VB.CheckBox", "chbCheckBox")
End Sub
This works for VB6 but not for VBA for me ?
/Johan





RE: loading dynamic controls in a excel VBA form ?
try the following:
Controls.Add("Forms.CheckBox.1", "chbCheckBox")
HTH
M. Smith