Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross 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

JohanJohansson

Computer
Jul 28, 2002
1
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
 
Replies continue below

Recommended for you

Sort by date Sort by votes
Johan,

try the following:

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


HTH
M. Smith
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

William Heath
  • Locked
  • Question
change active cell in excel
Replies
4
Views
37
IDS
IDS
Susangrizly
  • Locked
  • Question
How I circunavigated the problem with excel adding quotes to text
Replies
0
Views
23
Susangrizly
Susangrizly
pieswt
  • Locked
  • Question
Excel Macro File getting corrupted 1
Replies
3
Views
40
MintJulep
M
1503-44
  • Locked
  • Question
GPTchat for VBA
Replies
4
Views
49
1503-44
1503-44
William Heath
  • Locked
  • Question
VBA Excel Chart
Replies
6
Views
40
SkipVought
SkipVought

Part and Inventory Search

Sponsor

Back
Top