Retrieving value from a textbox

Question

I am trying to retrieve value from a textbox dynamically.

This code isn't working.

For i = 1 To TotalSheets

    ReqValue = ValidationForm.Frame6.ReportName(i).Value


Next

But this code does,

ReqValue = ValidationForm.Frame6.ReportName1.Value

I need to get the values dynamically through a loop.

What is your ValidationForm? A UserForm or something hand crafted using Form controls and / or ActiveX controls? — Alex P
– Alex P, Commented Jan 19, 2018 at 11:32
@AlexP It's an userform but those textboxes are created dynamically using vba code. — Student of the Digital World
– Student of the Digital World, Commented Jan 19, 2018 at 11:34

iSpain17 · Accepted Answer · 2018-01-19 11:34:37Z

3

Reportname(i) refers to an array.

Instead, you have to concatenate the name of your control:

ValidationForm.Frame6.Controls(“ReportName” & i).Value

answered Jan 19, 2018 at 11:34

iSpain17

3,1403 gold badges22 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1