Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm trying to remove controls from my form at runtime. The controls have already been added using something similar to the code below. For TeamLoop = 1 To 3 Set TeamChkBox = Controls.Add("Forms.CheckBox.1", "chkTeam" & TeamLoop, Visible) Next TeamLoop Does anyone know the syntax for removing these controls from my form? Ta. Neil |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Neil,
Try this Me.Controls.Remove "CheckBox1" -- HTH RP (remove nothere from the email address if mailing direct) "Neily" wrote in message ... Hi, I'm trying to remove controls from my form at runtime. The controls have already been added using something similar to the code below. For TeamLoop = 1 To 3 Set TeamChkBox = Controls.Add("Forms.CheckBox.1", "chkTeam" & TeamLoop, Visible) Next TeamLoop Does anyone know the syntax for removing these controls from my form? Ta. Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assigning events to runtime-created controls - is it possible? | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
How to create controls at runtime | Excel Programming | |||
Add Controls With Events at Runtime | Excel Programming | |||
creating controls at runtime | Excel Programming |