Control arrays and initialize does not work!

[tasamy]

When I have this code in UserForm_Initialize

Dim i As Integer
'clear textboxes
For i = 1 To 30
Set TextBoxArray(i) = Controls("TextBox0" & i)
TextBoxArray(i).Text = ""
TextBoxArray(i).Value = ""
Next i


It does not clear the textboxes.



but when I add a messagebox, it clears them.

Dim i As Integer
'clear textboxes
For i = 1 To 30
MsgBox(i)
Set TextBoxArray(i) = Controls("TextBox0" & i)
TextBoxArray(i).Text = ""
TextBoxArray(i).Value = ""
Next i


Excel 2003 and Windows XP

[contaminated]

Hi tesamy and welcome to the forum
However
Your post doesn't comply with the rule # 3
Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.