"Me.Controls" giving error Could not find the specified object.

[Abdulwahab]

Hi,

I'm trying to loop through textboxes and checkboxes.

It works fine for the checkboxes... but I get an error saying "Could not find the specified object" for the line that relates to textboxes.

heres the code:

Please Login or Register  to view this content.

I used it here too and it works fine: (vcheck is a boolean variable)

Please Login or Register  to view this content.

I matched the stuff inside the brackets of the function to what was in the "name" field for the textboxes.

Also, using the code:

Please Login or Register  to view this content.

.... etc. works fine.

Any help?

[Colin Legg]

Welcome to the forum, Abdul.

Please can you edit your first post and put code tags around your code? To see how, have a look in my signature.

That certainly looks like a strange error. I think the quickest way to solve this problem would be if you attached an example workbook to the thread?

[Abdulwahab]

Thanks for the warm welcome.

I went ahead and made the changes to my first post.

So I made an example workbook, and am attaching the actual workbook I was having problems with as well.

I demonstrated in the example workbook the area that I am having trouble with (though it works perfectly fine in the example workbook). Cycling through the textboxes in the second workbook that I'm attaching is giving me problems.

[royUK]

You don't have a sheet called Sheet1 so that's the first problem

This works

Please Login or Register  to view this content.

[Abdulwahab]

"Sheet1" was in the workbook "Book1" that I gave as an example.

I'm pretty sure the "iets-support-checklist" workbook's variables point to "Checklist"

[Colin Legg]

It errors when i=5 because in your userform you've missed txtBox5 out. The control sequence goes:

txtBox1
txtBox2
txtBox3
txtBox4
txtBox6
txtBox7
txtBox8
txtBox9
txtBox10
txtBox11
txtBox12
txtBox13

So it will error if i>13 too.

[Abdulwahab]

argh. Thank you so much. I'd been trying to figure this out for a while now.....