ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   add dynamic control (checkbox) (https://www.excelbanter.com/excel-programming/369763-add-dynamic-control-checkbox.html)

Pluut

add dynamic control (checkbox)
 

I don't know how many rows I will have (between 5 and 25), so I want t
create dynamic control. Does anybody know how to do this or how me
link were it is explained?

Thank you Pluu

--
Pluu
-----------------------------------------------------------------------
Pluut's Profile: http://www.excelforum.com/member.php...fo&userid=3723
View this thread: http://www.excelforum.com/showthread.php?threadid=56951


Pluut[_2_]

add dynamic control (checkbox)
 

For example, I try this for 1 checkbox, but it doesn't work.

Private Sub UserForm_Initialize()

Dim chb As Control

Set chb = Controls.Add("Forms.CheckBox.1)")

End Sub

How can I let this work?

Thanks Pluu

--
Pluu
-----------------------------------------------------------------------
Pluut's Profile: http://www.excelforum.com/member.php...fo&userid=3723
View this thread: http://www.excelforum.com/showthread.php?threadid=56951


Pluut[_3_]

add dynamic control (checkbox)
 

I solved my own (little) problem, a stupid mistake. One ) too much i
the code

Private Sub UserForm_Initialize()

Dim chb As Control

Set chb = Controls.Add("Forms.CheckBox.1")

End Su

--
Pluu
-----------------------------------------------------------------------
Pluut's Profile: http://www.excelforum.com/member.php...fo&userid=3723
View this thread: http://www.excelforum.com/showthread.php?threadid=56951



All times are GMT +1. The time now is 02:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com