Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create controls at runtime
I want to create a list of checkboxes at runtime.
What is the best way to do it ? I used the following Dim ctlName As Control Set ctlName = Controls.Add("Forms.Checkbox.1", True) It works, but how do i add a name for the checkbox ? There is no text or caption method that goes along with it. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create controls at runtime
ctlName.Name = "CheckBox1"
-- Vasant "Andy Chan" wrote in message ... I want to create a list of checkboxes at runtime. What is the best way to do it ? I used the following Dim ctlName As Control Set ctlName = Controls.Add("Forms.Checkbox.1", True) It works, but how do i add a name for the checkbox ? There is no text or caption method that goes along with it. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create controls at runtime
Hi Vasant, The name does not appear on the form. Why is this so ? Regards, Andy *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create controls at runtime
You need
ctlName.Caption="Andy" -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Andy Chan" wrote in message ... Hi Vasant, The name does not appear on the form. Why is this so ? Regards, Andy *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime error 429 when trying to create Inet object | Excel Discussion (Misc queries) | |||
Assigning events to runtime-created controls - is it possible? | Excel Discussion (Misc queries) | |||
Add Controls With Events at Runtime | Excel Programming | |||
creating controls at runtime | Excel Programming | |||
Create controls dynamically | Excel Programming |