Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping through all checkbox's in a userform
Hi,
I have 35 checkboxes in my userform. For each checkbox that is true I will do 'x'. Anyone know the syntax to loop through all the checkboxes? Thanks, Robin ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping through all checkbox's in a userform
Hi Robin:
Dim ctl As Control For Each ctl In UserForm1.Controls If TypeOf ctl Is MSForms.CheckBox Then If ctl Then 'your code here End If End If Next Regards, Vasant. "strataguru" wrote in message ... Hi, I have 35 checkboxes in my userform. For each checkbox that is true I will do 'x'. Anyone know the syntax to loop through all the checkboxes? Thanks, Robin ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping | Excel Discussion (Misc queries) | |||
Not Looping | Excel Discussion (Misc queries) | |||
Looping | Excel Discussion (Misc queries) | |||
declaring an array of CheckBox's | Excel Programming | |||
looping through worksheets | Excel Programming |