Loop Through A Series of TextBoxes in a Userform

[Ark68]

I have a userform with a series of 8 textboxes each holding a unique value.
I am looking for code that will step through each one of these 8 boxes to gather the value so that I can use that value in further code.

I am not sure how to set up a loop referring to the 8 different textbox names.

I'm sorry if I'm vague with my details. Please let me know if I've forgotten some critical information / expectations if you're willing to help.

 

[Norie]

How are the textboxes named?

 

[Ark68]

Hi Norie, thanks for your reply.

Unsure if this is what you were looking for in an answer ... cu2_en, cu3_en, cu4_en, cu5_en, cu6_en, wprk1_en and wbvd1_en. All hold a 5 digit number.
Once I get the number, each one will be applied to it's own lookup routines to fill cells in a worksheet.

If there is a solution I will have to similar scenario in another worksheet, so I hope there is a solution.

 

[Norie]

You could try something like this.

Dim I As Long

    arrCtrls = Array("cu2_en", "cu3_en", "cu4_en", "cu5_en", "cu6_en", "wprk1_en","wbvd1_en")

    For I = LBound(arrCtrls) To UBound(arrCtrls)
        valLookup = Me.Controls(arrCtrls(I)).Value

        '
        ' do stuff with value from textbox
        '
    Next I

 

[Ark68]

Hello Norie,
My apologies for not acknowledging your help until now. I hadn't had an opportunity to try it out.
It works wonderfully so far!!
I did have to make one minor adjustment. Since the controls were actually labels, i had to change .value to .caption in this line ...

valLookup = Me.Controls(arrCtrls(I)).Caption