VBA Code Help

[gnaga]

Hi,

I have a userform with 25 textboxes. I have named each of them as txtDesp1,txtDesp2....txtDesp25"

I would like to change its property by using them in the For...Next Loop

I am using as follows
<pre>
Private Sub UserForm_Activate()
Dim I%
For I = 1 To 25
"txtDesp" & CStr(I) = ""
Next I
End Sub
</pre>

This code is not getting executed. Since there is no Index feature in VBA userform controls. Is there any other way to change the controls property in For Next Loop?

Thanks.

GNaga

 

[Juan Pablo González]

You can/have to use the Controls collection of the userform

Me.Controls("txtDesp" & I).Object = ""

 

[gnaga]

Thank you so much Juan. It is really much much useful. Thanks Again.

GNaga