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!

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

Sidtha
  • Locked
  • Question Question
Export Bundle Segnment Properties to excel
Replies
0
Views
2K
Sidtha
Sidtha
William Heath
  • Locked
  • Question Question
change active cell in excel
Replies
4
Views
1K
IDS
IDS
Susangrizly
  • Locked
  • Question Question
How I circunavigated the problem with excel adding quotes to text
Replies
0
Views
802
Susangrizly
Susangrizly
pieswt
  • Locked
  • Question Question
Excel Macro File getting corrupted
Replies
3
Views
1K
MintJulep
M
1503-44
  • Locked
  • Question Question
GPTchat for VBA
Replies
4
Views
1K
1503-44
1503-44

Part and Inventory Search

Sponsor

Back
Top