Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
for i = 1 to 10
controls("CheckBox" & i).Value = False Next as an example. another approach for each ctrl in Userform1.Controls if typeof ctrl is MSForms.CheckBox then ctrl.Value = false end if Next -- Regards, Tom Ogilvy "Ben.c" wrote in message ... Euh..... I am sorry but I am not sure of how do I create their name as a string ? Do I have to use checkbox.name to rename them ? Thanks for help Stephen Benjamin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Checkbox | Setting up and Configuration of Excel | |||
Checkbox | Excel Discussion (Misc queries) | |||
Font Issues when using UserForm box after clicking a Checkbox | Excel Discussion (Misc queries) | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
Conditional Checkbox Creation on a UserForm | Excel Programming |