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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through controls
Sub userform1_activate()
For each ctrl in userform1.controls if typeof ctrl is MSForms.Label then ctrl.caption = "test" end if next End Sub -- Regards, Tom Ogilvy "Libby" wrote in message ... 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 |
Reply |
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 |