Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

loading dynamic controls in a excel VBA form ?

Status
Not open for further replies.

JohanJohansson

Computer
Joined
Jul 28, 2002
Messages
1
Location
SE
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
 
Johan,

try the following:

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


HTH
M. Smith
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top