Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through controls
Hi
How do you loop through the labels on a userform and ignore other controls such as commandbuttons? When I try and do this using the code below, I find that all the controls are included in the loop. Sub userform1_activate() For each label in userform1.controls label.caption = "test" next End Sub Many thanks in advance L |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping through listbox controls | Excel Programming | |||
Looping through controls on form | Excel Programming | |||
looping through userform controls | Excel Programming | |||
Looping through multiple controls | Excel Programming | |||
Looping thru custom controls | Excel Programming |