Variables in control names 1

[jadedinvasion]

Is it possible to use counter variables in control names?

I have a series of dropdown boxes named cboDept1, cboDept2, cboDept3 ect.. and was wondering if I could reference them in my module with a variable instead of hardcoding the names.

Something like cboDept & intCnt &.value (I know that doesn't work, but it kind of details what I'm tryin to do)

Any ideas would be fantastic! Thanks

 

[stevexff]

Something like

    For i = 1 To 6
        UserForm1.Controls("CBODept" & i).Value = True
    Next

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[jadedinvasion]

bah! I should totally know that...

Thanks for your help!