calling text box in VBA

[VBAmalta89]

i have a series of text boxes with the name power1_1, power 1_2 etc.

I need to call them in a procedure but the numbers 1 and 2 are changing so i applied the following section of code:

If Me.Controls("power" & j & _i).Enabled = True Then

this didnt work as it kept prompting an error that points me to this code.

any idea what could be wrong please?

 

[GTO]

I think you may just need to note the underscore as a string.

If Me.Controls("power" & j & "_" & i).Enabled = True Then

 

[VBAmalta89]

yes that was it

thanks!

 

[GTO]

Happy to help