Dynamically Assign Objects to Form Objects.

[The Vision Thing]

I have ten listboxes on a form, ddlwb1, ddlwb2 etc. I want to loop through
them and dynamically assign them to an object like so:

For i = 1 To 10
Set objDdl = ddlwb & i
'do something else with objDdl
Next

Obviously this doesn't work, but I vaguely recall a command that will make
it work, though for the life of me I can't remember what.

Thanks,
Wayne C.

 

[Tom Ogilvy]

For i = 1 To 10
Set objDdl = Userform1.Controls("ddlwb" & i)
'do something else with objDdl
Next

 

[The Vision Thing]

Thank you Tom, worked like a charm.

Wayne C.