Help converting String to Form Object Name

I want to know if it is possible to use a string variable to reference a form object name.

Capture.PNG

I have 9 check boxes and 9 text boxes, and I only want each text box to be enabled if the subsequent check box is checked.
The check boxes are named Dur1, Dur2, ... , Dur9. The text boxes are named Setup1, Setup2, ... , Setup9.

I want to do something like this, but can't figure out how:

Please Login or Register  to view this content.

This code obviously doesn't work.. Is there a way that I can do this?

If this is on a userform you can use the form's Controls collection.

Please Login or Register  to view this content.

Thanks! I will give this a try

I tried this and I am getting a "Could not find object" error for Me.Controls(SetupStr)

That could be because you used Str.

You don't need to convert the number to a string and when you do using Str a space is added at the front.

So in the code you are generating names like 'Dur 1' instead of 'Dur1'.

Finally working! Just had to use CStr. Thanks!

You shouldn't need to use anything.

This will work just fine.

Please Login or Register  to view this content.

For some reason that was giving me a type mismatch..

Do I have to declare DurStr as something other than a String?

It would be giving that error because you used + instead of &.

That was indeed the problem. Thanks again!

@ buley004

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.