userform - help needed

[Elane]

Hello to everyone.
I created a userform (UserForm1), and inside this form I placed 20 textboxes and 20 checkboxes.
Everytime I make the userform to appear, I need all the checkboxes to be false and all the listboxes to be empty
One question at a time...
I can write down 20 rows to set each checkbox value=false but I would like to have something better
I tried

For i = 1 To 20
UserForm1.Controls("CheckBox" & Chr(64 + i)).Value = False
Next i
but it says runtime error, impossible to find the specified object
These instructions are placed in the command button macro, just before the UserForm1.show line

How can I fix the error?
Thanks to everyone

[georgiboy]

Hi Elane, welcome to the forum.

Try as below:

Dim i As Integer

For i = 1 To 3
UserForm1.Controls("CheckBox" & i).Value = False
Next i
UserForm1.Show

Unless your checkbox's are named 'CheckBoxA', 'CheckBoxB' etc.?

[arnelgp]

you may also try this on the Activate event of your UserForm


Private Sub UserForm_Activate()
Dim ctl As Control
For Each ctl In Me.Controls
If TypeOf ctl Is TextBox Then
ctl = ""
ElseIf TypeOf ctl Is CheckBox Then
ctl = 0
End If
Next
End Sub